topic Re: Filtered listbox selection in QlikView

Filtered listbox selection

Thu, 19 Dec 2013 09:40:05 GMT

Hi everybody,

i've a little problem this morning and, i'm not able to resolve it since two days.

On a simple liste box selection I just want to display 3 values.

This listbow selection is composed of 12 possible values.

For example :

I create a listbox slection named "month" wich is composed by the 12 month of year, and I want to only display the month : " march, april and may", even if the other month could be selected.

thanks for helping

Re: Filtered listbox selection

Thu, 19 Dec 2013 09:45:55 GMT

Use the following expression in the listbox:

if(WildMatch(Month,'Mar', 'Apr', 'May'), Month)

Note that calculated dimensions like this affect performance. Better to create a new calculated field in the script.

Re: Filtered listbox selection

Thu, 19 Dec 2013 09:50:34 GMT

Thx everybody

fast, clear , perfect

Re: Filtered listbox selection

Thu, 19 Dec 2013 09:53:35 GMT

One of the many ways to do it is to have an expression in the list box:

=if(Match(Month,'Mar', 'Apr', 'May'), Month)

Or you can also use

=If(Month='Mar' or Month = 'Apr' or Month = 'Nov', Month)

But using such calculations may affect performance in some cases, so its always to do these things in script.

Hope this helps!