Cross Table In QlikView

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




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:



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





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





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




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




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




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




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




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




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




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




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



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




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




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




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




Step 22: Again follow this process:




Step 23: Click on the cross table button.




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




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




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




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




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




Summary

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