Creating Table Box in QlikView

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.

Creating Table Box in QlikView 1

From the screenshot below, see that we are loading the above specified excel sheet into the QlikView.

Creating Table Box in QlikView 2

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 3

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

Creating Table Box in QlikView 4

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.

Creating Table Box in QlikView 5

Either way opens a new window called New Table Box. Refer Import data from Excel to QlikView article in QlikView to import the excel tables.

Creating Table Box in QlikView 6

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.

Creating Table Box in QlikView 7

Now, see our newly created table report in QlikView.

Creating Table Box in QlikView 8

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.

Creating Table Box in QlikView 9

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.

Creating Table Box in QlikView 10

Use the Clear shortcut to undo the Filter or selection

Creating Table Box in QlikView 11

Comments are closed.