Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.