Cross Table In QlikView

Introduction

The cross table is also known as a 2-way table. This table consists of both columns and rows. It can be used to display the subtotals for columns.

The following is the procedure for using a cross table in QlikView.
  

Step 1: Open the QlikView application, then go to:

"File" -> "New"

Then the following window will be opened:

After clicking New option


Step 2:
Select a data source from my Excel file.

Browse our file



 Step 3:
Then we need to browse to our Excel file and open the our Excel file, then this window will be opened.

click on next
 

Step 4: After browsing to our file, we need to verify the data.

Verify the data


Step 5:
After verifying the data, double-click on the "Next" button; we need to save our QlikView file.

Save the Qlikfile


Step 6:
After saving the QlikView file, we need to select the chart type. The chart shows the representation of the data.


Select the chart type


 Step 7:
The next step is to define the data dimensions and objects. The dimension shows the grouping of calculated data.

Define the objects
 

Step 8: The next step is to add an expression. This is an important step because the expression defines the calculated values in the chart.

Add expression
 

Step 9: This is the final step, this window will show the final representation of the data.

finalstep


After following this process, we create another QlikView file. The name of this file is CrossTable.qvw.

Now the final window of Normal Load and Cross table load is:

Window of Normal and Crosstable

Step 10:
Now open the Edit Script of Normal load and write this code:

Code of Normal Load



Step 11:
The next step is to click on the table files.


table files


Now when we click on table files, we again open the Excel file.

Window of again QlikView file


 Then simply double-click on the Open button, this window will be opened. Then click on the "Finish" button.

after opening the QlikView file


Step 12:
The next step is Reload the edit script.

reload the edit script


Step 13:
After reloading, this window will be opened.

After reloading


Step 14:
The next step is to simply click on the table viewer in the tool bar.

click on tool bar


Step 15:
After clicking on the tool bar this window will be opened.

After clicking on tool bar


Step 16:
Now we open the edit script of the cross table window.

crosstable


Step 17: The next step is to click on the table files.

table files


Step 18:
Now when click on the table files, we again open the Excel file.

Window of again QlikView file

 Then simply double-click on the Open button, this window will be opened.

after opening the QlikView file


Step 19:
Simply click on the "Next" button.

Click on next button


Step 20:
After clicking on the "Next" button, this window will be opened.

After click on cross button


Step 21:
Again, after clicking on the "Next" button:

After click on Next button1


Step 22:
Again follow this process:

After click on Next button2


Step 23:
Click on the cross table button.

click on cross button


Step 24:
After clicking on the cross button, click on the "OK" button.

After click on cross button


Step 25:
The last step is to click on the "Finish" button.

click on finish button

 
Step 26:
Now we write this code in the Cross table edit script and reload it.

code of crossload


 Step 27:
This window will be opened. Click on the table viewer in the tool bar.

table viewer

 
After that is the last and final window of the cross table in the QlikView application.

lastone


Summary

This section described the basic procedure for generating the cross table in a QlikView application.