Qlikview List Box – Display only Active Values

This post demonstrates how to configure a Qlikview List Box to display only active values.  This comes in handy when you are trying to limit the contents of a List Box object, only to values that are possible to select, based on selections in other List Boxes.  I use this technique to display active “possible” selection values, so there is no confusion for the user.  Also, this eliminates any need to scroll to the bottom of a list box to see selectable values.

 

Setup – Qlikview List Box – Display only Active Values

Setup a new Qlikview file and import data (you can find the data and LOAD SCRIPT for my example at the end of this post).

Add two List Boxes.

Qlikview List Box - Display only Active Values

Next, copy the second List Box (Player in my example), and place it right next to the original.

Qlikview List Box - Display only Active Values

Go into the properties of the List Box you just made a copy of (2nd Player List Box, on the right).

In the “General” tab under the “Fields” drop-down, select <expression>

Qlikview List Box - Display only Active Values

In the Edit Expression window, add the following formula:

=aggr(only({<Player= P(Player)>}Player),Player)

Qlikview List Box - Display only Active Values

Click OK, then add a title to the List Box.

Now, select “QB” in the Position List Box.

Qlikview List Box - Display only Active Values

There you have it!  The original Player List Box filters the active values in white and to the top.  However, the inactive values still appear at the bottom in grey.

In the custom List Box “Player (Active Only)”, only active values appear in the List Box.

 

LOAD SCRIPT

Here is the LOAD SCRIPT if you would like to give it a try:

 

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