[QlikView教程]T0 安装环境以及简单的例子

access_time 8 years ago visibility1551 comment 0

QlikView是一款在数据可视化展示方面有很大特长的BI工具,可以提供比较全面的Dashboard的制作。本文将简单阐述此工具的安装使用,并介绍一个简单的例子。在本系列中会陆续介绍QlikView的各种功能。

下载以及安装QlikView

QlikView官网下载地址:Downloads。下载后按照向导安装应用程序;建议选择全部安装所有功能。

以下为Windows64位版本的初始界面:

image

在菜单栏有以下子菜单:

  • File:可新建QV报表,打开远程报表,源代码控制等

image

  • View: 重置窗口大小,工具栏选择,窗口选择等

image

  • Settings:用户选项设置

image

  • Tools:工具
  • Windows: 窗体布局控制
  • Help:帮助,网站链接,版本信息等

image

新建报表

为了简化,本例将直接使用向导支持的Excel作为数据源

Excel示例如下(包含Title、Category、CreatedDate、LanguageCode四列):

image

1)点击工具栏的New图标或者菜单栏File->New (Ctrl+N),打开新建向导

2)选择数据源

在File Path中选择Excel文件的地址,然后点击Next:

image

3) 验证数据

注意勾选文件包含列名。

image

点击Next进入下一步。

4) 选择保存文件的地址

文件地址为新建的QlikView文件地址。选择后点击Next进入下一步。

image

5) 选择图表类型

本例选择Bar chart

image

点击Next进入下一步。

6) 选择Dimension

在本例中,Dimension的选项是Category以及CreatedDate 。

image

点击Next进入下一步。

7) 添加表达式

默认的表达式支持SUM、Average、Count等。本例中选择Count(Title)作为图表中的value。

image

点击Finish完成设计。

示例

完成后,可对布局进行额外的调整。下图为选择".NET Framework " "C#" "C/C++" 三个分类后,在不同日期发布的博客数量柱形图。

image

打开编辑脚本修改为:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';


LOAD Title, 
     Category, 
     Year(CreatedDate) as [Year], 
     LanguageCode
FROM
[C:\Users\Raymond\Desktop\QV-BlogPosts.xlsx]
(ooxml, embedded labels);

然后在菜单栏File->Reload 重新加载数据,即可查看到如下结果:

image

(上图为C#分类在不同年份发表的博客文章数量统计图)

通过设置允许的图表类型,还可以在不同图表类型中切换:

image

综上,QlikView的数据展示功能还是比较优秀的;通过简单的操作,即可以创建比较美观的报表。

后续的教程将不断增加新的内容,欢迎关注本系列博客: RSS

info Last modified by Administrator at 4 months ago copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Want to publish your article on Kontext?

Learn more

Kontext Column

Created for everyone to publish data, programming and cloud related articles.
Follow three steps to create your columns.


Learn more arrow_forward

More from Kontext

Create Business Reports using SSRS

local_offer plot

visibility 945
thumb_up 0
access_time 7 years ago

Serial: An Introduction to SQL Server Features After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service). The general requirements for in this scenario are: Sales performance in different areas Sales amount for different products ...

Power BI Analytics - Connect to DBMS and Card

local_offer plot local_offer power-bi

visibility 510
thumb_up 0
access_time 3 years ago

Power BI supports connecting to most of the DBMS databases such as SQL Server, Oracle, Teradata, MySQL, DB2, Sybase, Snowflake, Google BigQuery, Impala and etc. This page summarizes the steps to connect to SQL Azure and to create the following part of the sample dashboard of this series ...

Machine Learning with .NET in Jupyter Notebooks

local_offer plot local_offer machine-learning local_offer jupyter-notebook local_offer C# local_offer dotnetcore

visibility 935
thumb_up 0
access_time 12 months ago

In this article, I'm going to show you how to install Jupyter in Windows and then install .NET kernel for Jupyter notebooks. It also shows a machine learning example using ML.NET. The target audience are .NET developers who want to expand their skills in data engineering and science domain with ...