Creating Pivot Table In QlikView Application

Pivot Table in QlikView application

A Pivot Table is a data summarization tool found in business intelligence software or spreadsheets. The Pivot Table can be used to count, total or average the data stored in a table, spreadsheet or SQL database table. A Pivot Table can be used for automatic sorting purposes.

Creating a Pivot Table in QlikView application

Step 1:
Open the QlikView application

It is the first step, in this step you must open the QlikView application then go to "File" -> "New" then this window will be opened.

After clicking New option

Step 2: Open Edit Script

The second step is to open the edit script window from "File" -> "Edit Script".

window of edit Script

  • Then this window will be opened.

    window

Step 3: Click on "Table Files...".

table file

In this step we import our Excel file and click on the Open button.

local file

Step 4: File wizard type

Then this window will be opened. Here you can see your Excel file table and click on the Finish button.

File wizard

Step 5: Code of edit script

Now, in the edit script the Excel file is uploaded successfully and reload it.

reload

Step 6: Save file

The next step is to save our QlikView file.

save file

Step 7: Sheet property window

The sheet property window will be opened. In this window you add fields that you want to display as a table and click on the OK button.

sheet

Then you will see this window.

main

Step 8: Select chart

In the menu bar, there is an option of layout then click on layout and select chart.

chart

Step 9: General Window

In this window there is an option for Pivot Table, then select Pivot Table and click on the Next button.

General

Step 10: Add dimension

In this window we add a dimension because dimensions describes calculated data.

dimension

Step 11: Edit expression

In this window we perform an aggregate function with a dimension and click on the OK button.

Edit

Step 12: Expression window

Then this window will be opened and click on the Finish button.

Expression

Step 13: Final window

Then you will see the Pivot Table.

final1

Summary

 

This article introduced Pivot Tables in QlikView and also describes how to create a Pivot Table in a QlikView application.