Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

limit values displayed in list box to a few values

I have a country list box with over 100 values and want limit display to 2 (US, CA) or 3 (US, CA, MX).

How do you do this? if statement or an only statement?

Thanks,

Jimmy

3 Replies
Not applicable
Author

Hi,

first of all I ask you if you whant only that values because u have not data for others...

In that case I suggest you to load that field with "where exists(..)"clause in the script.

Otherwise you can add a list box, but choose not field, but <expression> and in that way you can filter your field with some expression

C u,

Stefano

Not applicable
Author

I have other values but the are outliers and are not needed in this particular instance.

What would the expression be for the list box?

Not applicable
Author

Hi shanfeld,

try this expression in your listbox:

=if( mixmatch( Col_B, 'US', 'CA', 'MX'), Col_B)

RR

P.S:

If you are able to change the loadscript, I would prefer this (like Stefano posted above) instead of calculating it online within a listbox.