How to show selected fileds in list box

[#1]

Hi All,

I have the requirement to show selected countries like 'U.S.A','Japan','Italy' in a list box how to do it .

Thanks in Advance..

[roger_stone]

You mean you have a set of countries but only want to populate the list box with a subset of them?

[sinanozdemir]

Is this what you are looking for?

I use Aggr() in the listbox:

Or choose "Hide Excluded":

Hope this helps.

[Anonymous]

Hi, try with expression

=If(Match(Planta,$(vConcat))>0,Planta)

and this variable

vConcat

=chr(39)&Concat(DISTINCT Planta,chr(39)&','&chr(39))&chr(39)

with the "=" simbol please in the variable