Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
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
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?
try this expression in your listbox:
=if( mixmatch( Col_B, 'US', 'CA', 'MX'), Col_B)
If you are able to change the loadscript, I would prefer this (like Stefano posted above) instead of calculating it online within a listbox.