The Table Box in QlikView is a sheet object which is useful to show several different fields simultaneously from one or more internal tables. Let us see the steps involved in creating a table box in QlikView with an example. For this QlikView Table Box demo, we are going to use the data present in the following Excel table.
From the screenshot below, see that we are loading the above specified excel sheet into the QlikView. Refer Import data from Excel to QlikView article to import the excel tables.
Right-click on the Main tab, and select the Sheet Properties.. to change the tab name as per requirements. Here, we are changing it Table Box
Creating Table Box in QlikView
We can create a QlikView table box in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the table Box.. option
The second approach is to right-click on the Empty report area opens the Context menu. Please select the New Sheet Object, and then select the table Box.. option. Alternatively, click on the Create Table Box shortcut present in the toolbar.
Either way opens a new window called New Table Box
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. Visit the QlikView Table Box Properties article to understand each property present in this window.
Now, see our newly created table report in QlikView.
Use this QlikView 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.
From the screenshot below, see when we click on the Professional row in the Table box. The Bar chart displays the Bar for Professionals only.
Use the Clear shortcut to undo the Filter or selection