The List Box in QlikView is the most basic sheet object which is used to show all the records present in the selected column. In this article we will show you the complete steps involved in creating a list 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 Employee 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.
Create a List Box in QlikView
We can create QlikView List box in multiple ways: Please navigate to Layout Menu, select the New Sheet Object, and then select the List Box.. option as we shown below
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 List Box.. option. Or you can click on the Create List Box shortcut present in the toolbar.
Either ways, it will open a new window called New List Box as we shown below:
- Title: You can write the custom title for your list box.
- Field: Please select the Column name that you want to display in the List box. For example, if you want to display the State Names from your data base then you have to select the State Column as the filed.
- Use as Title: If you check mark this option, it will use the Column name as the List box title.
From the below screenshot you can see that, we are selecting the Occupation as the Filed Value, and we are also using the filed name as the Title
Let me sort the List box data in Ascending Order so that, it will be easy to find the required filed. Here, you can sort the Occupation data in Ascending, or Descending order.
Please change the Font family, style, and size of the font as per your requirements. From the below screenshot you can see that, we changed the Font to Lucida Sans, and font size to 11
Now you can see our newly created table List Box in QlikView.
You can use this List 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 List Box sheet.
As you can see from the below screenshot, when we select the Professional, Management fields in List box the Bar chart is also display the Bar for Management, and Professional only.
You can use the Clear shortcut to undo the Filter, or selection
Thank You for Visiting Our Blog