Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
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.