Getting Started with Qlikview: Loading a database table creating a Perspective view (verbose)

Making income contract analysis data with Qlikview
1. Installation and use of Qlikview
See "qlikview_11_ Chinese Reference Manual full version _v1.0"

Qlikview Data Extraction Step "to connect a database as an example"
Create a new file:

To edit the current script:

Select the OLE DB data source:

Click "Connect"

Click "Next" (here is an example of connecting a SQL SERVER database)
Enter the database's IP, user name, password, and then select a database

Click "Test Connection"

The script now contains the information to connect to the database:

Close the data source and see how to pull the data out of the data source.
Retrieving data
In the Script Editor panel, click "Select"


Drop-down to select a table, the default is to select all the fields of the table, you can "press CTRL" at the same time to select multiple columns, and finally click "Add" to complete a table selection. However, it is best to use CTRL to select multiple fields so that you can choose from the following list when creating dimensions and expressions.

Click "OK" to close the Script editing window. Click "Reload" to import the data into Qlikview:


Save the document and import the data automatically.

Click on "Table Viewer"

You can see the table structure of the imported table

2. Qlikview to create a Perspective view
Create a new chart in the main worksheet

Select Pivot Table

Click "Next" to introduce the concept of Qlikview's "dimensions" and "expressions", which are used for grouping and expressions for grouping calculations, so a perspective is usually a dimension and expression.
Add dimension
(You can also click "Finish" directly) and then add it by right-clicking the Perspective "Properties".

Add an "expression"
(You can also click "Finish" directly) and then add it by right-clicking the Perspective "Properties".

Expressions are divided into two types:
Write the expression in the form of a scripting language, or you can choose from the "field" selector below (here, for example)

Click "Paste", "OK"

You can only add one expression at a time, add multiple expressions to repeat the procedure, name the expression "label" to display in the perspective, the most common expression is to sum the dimensions grouped, so the following expression is the sum of the fields

Click "OK" to see the Perspective view,

Select "Expand All"
You'll see the full details.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Getting Started with Qlikview: Loading a database table creating a Perspective view (verbose)