Qlikview List Box

Once you have created your Qlikview application and loaded the data, the first task you will often perform is adding List Box objects to your sheet.  This is a very simple task:

Right-click on your mouse, then select Add Object-List Box:

 

Qlikview List Box

 

Or, right-click on your mouse, then choose Select Fields

 

Qlikview List Box

 

You can then select which available fields from your data model that you would like to create a List Box for.  I chose to use the “NFLTeam” and “Player” fields:

 

Qlikview List Box

 

Click apply and the List Box objects will appear like this:

 

Qlikview List Box

 

There are a number of formatting options you can configure at this point.  For starters, you can browse through the properties for each List Box object.  Simply right-click in the header area of the List Box and select Properties.  In my case, I wanted to change the title of the NFLTeam List Box to “Team”, and I want to know how many times each team appears in the data model.  Just check the “Show Frequency” box and you will see the following updates:

 

Qlikview List Box

 

This added feature illustrates the frequency each value of NFLTeam appears in the data model.  You can sort the List Box based on the frequency, which immediately shows which teams are the most prevalent in your data.  Very useful.  By displaying these counts, the user is able to garner valuable information, and we haven’t even inserted any charts or aggregation objects!

Another feature available in the List Box object is the ability to setup expressions.  Let’s say I wanted to know how many fantasy points the players on each NFL Team have scored.  You can setup the following expression:

 

Qlikview List Box

 

Configured to sort in descending order by the sum(FPTS), you can see which NFL Team has accounted for the most fantasy football player points from top to bottom.  With the counts of players right next to the sum total, users are beginning to see the overall picture.  But it would be better to determine an average points for each player on a given team.  You can modify the expression to calculate the average, then sort the result in descending order:

 

Qlikview List Box

 

Another nice feature is the search capability.  If you wanted to select the top NFL Teams, you can click on the search eyeglass icon in the List Box header (top right corner), and type an expression to base the filtering on:

 

Qlikview List Box

 

The example above is based on a very simple expression, but this technique can be taken to much more advanced levels, using set analysis, variables, etc.

One final feature that I find is a nice touch for the display  is changing how the presentation of the List Box appears in the application.  I sometime like to make the List Box appear like a list of checkboxes, so the user can click a check next to those value they want to include in the filter:

 

Qlikview List Box

 

Conclusion

As you can see, the List Box object is actually quite versatile.  I tried to demonstrate a few techniques that may not be obvious when working with the Qlikview List Box object.  These have come in handy as I’ve developed applications, and I find them very useful in my day-to-day work.  I encourage you to share your comments about this post and offer any additional techniques using this object that are uncommon to most users!

 

Additional Content

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

Leave a Comment