Join Curt Frye for an in-depth discussion in this video Creating a List box, part of Up and Running with QlikView.
- QlikView lets you summarize large data collections efficiently. Many times you'll want to summarize just a subset of your data, which means you need to create controls to select what you want to see. In this movie, I will show you how to create one of those controls called a list box. My sample file is the "create list box report" and you can find it in the chapter two folder of the exercise files collection. To create a list box, you open a report and then go to the layout menu, point to "new sheet object," and then click list box.
Doing so displays the new list box dialog box. The first thing you can do is type a title, or use an existing field as a title. So let's say that I want to limit my data based on state. To do that, I would click the field control's down arrow, and from the list of fields that are available, I'd click state. And just to clarify, a field is the same as a column in your original data source. So each of the orders in my original data source has a state name, so I'm just searching based on that name.
And if I want to use "State" as the title, I can just leave the "use as title" checkbox selected. There are other options I could set, and I'll talk about two of them here. The first is to check, or uncheck the box to "hide excluded." What that does is, if you select items to display within a list box, then you can either display every item that's available, or you can hide the ones that aren't currently being seen. If you have a large number of items, different items, within a list box, then hiding excluded can be useful.
However, if you only have, say, 20, or maybe 30, or more, depending on your comfort level, then leaving the "hide excluded" box unchecked is probably the right way to go. But, again, it's your visualization, I don't know exactly how you work, I just wanted to let you know that that option is available. The next option is to figure out how you want to sort the values within your list box. To do that, click the "sort" tab. You can either list the states in ascending order, that is, alphabetical, using the tech setting here, or you could, if you wanted, click the state down arrow, and click "descending," or you could select some other criteria.
For states, it's pretty obvious that you want to go in ascending order, and ascending alphabetical order, but if you have some other type of data inside your list box, then you might want to change how it is sorted. But in this case, everything looks right. I'll go ahead and click "okay." And you can see that I have my state list box over on the left. Now I'll go into filtering a lot more later on, but just to show you the value of the list box we just created, I'm going to go over and click "Idaho." Clicking that item highlights it within the state list box, and you can see that my chart changed so that it only displays sales from Idaho.
So that's all that's summarized there. If I hold down the control key, and click "Oregon" as well, now I have both of those states, and I have filtered so that the chart is only showing sales from Idaho and Oregon. One other thing I'll note before I close is that you can create multiple list boxes, and use them to create multilayered criteria to limit the data that appears in your report. You'll be working with list boxes a lot in Qlikview, so that's why I thought it was important to introduce them early.
- Installing QlikView
- Setting user preferences and document properties
- Creating visualizations
- Adding objects like List boxes, Multi boxes, and containers
- Adding, deleting, and moving sheets
- Sorting and filtering QlikView data
- Creating charts and pivot tables