The Table Box in QlikView is a sheet object which is used to show several different fields simultaneously from one or more internal tables. In this article we will show you the steps involved in creating table box in QlikView with example. For this we are going to use the data present in the following Excel table.
From the below screenshot you can see that, we are loading the above specified excel sheet into the QlikView. I suggest you to refer Import data from Excel to QlikView article to understand the steps involved in importing the excel tables.
Right click on the Main tab, and select the Sheet Properties.. to change the tab name as per your requirements. Here, we are changing it Table Box
Creating Table Box in QlikView
We can create QlikView table box in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the table Box.. option
Second approach is to right-click on the Empty report area will open the Context menu. From the context menu, Please select the New Sheet Object, and then select the table Box.. option. Or you can click on the Create Table Box shortcut present in the toolbar.
Either ways, it will open a new window called New Table Box as we shown below:
We added all the available filed into the Table Box by clicking the Add All >> button. Though this window has many properties, we are not going to discuss any of them in this article. So, click Apply to apply the changes, and then click OK to close the window. You can visit QlikView Table Box Properties article to understand each and every property present in this window.
Now you can see our newly created table report in QlikView.
You can use this table Box to filter the data present in Charts, or other boxes present in the sheet. To demonstrate this concept, we are adding a Bar Chart to this existing Table Box sheet.
As you can see from the below screenshot, when we click on the Professional row in Table box the Bar chart is display the Bar for Professional only.
You can use the Clear shortcut to undo the Filter, or selection
Thank You for Visiting Our Blog