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.



Step 2: Open Edit Script

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

• Then this window will be opened.
  
  
  

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



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



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.



Step 5: Code of edit script

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

Step 6: Save file

The next step is to save our QlikView 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.

Then you will see this window.

Step 8: Select chart

In the menu bar, there is an option of layout then click on layout and select 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.

Step 10: Add dimension

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

Step 11: Edit expression

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

Step 12: Expression window

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

Step 13: Final window

Then you will see the Pivot Table.



Summary

 

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