Loading A Table From Excel File Into QlikView

How to load a table from Excel in to QlikView

Introduction

The QlikView application are very useful for the original data source. With in few minutes we load a table from Excel in QlikView.

Use the following procedure to load the table into QlikView.

Step 1: Open the QlikView application, then go to "File" -> "New" and then this menu will be shown:



Step 2: Select a data source from an Excel file as in the following:

 

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

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



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



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



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

Step 8: The next step is Add expression, this is an important step because the expression defines the calculated values in the chart.

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



Step 10: The next step is to open the edit script to load the data, then this window looks like this:



Step 11: After opening the edit script we write the code, then debug it as in the following:



Step 12: After the debugging process, the next step is to run the application. The script will then be finished and the window will look like this:



After finishing this process the table of the Excel file is loaded successfully.

Summary

This article described the basic procedure to load a table into a QlikView application. The procedure is very simple.