Filter Values In List box

[dsharmaqv]

Hi

I want to filter values in list box and display only couple of values. can some one assist me to get this.

Country

India

US

UK

Brazil

I want to display only India and UK in my list box.

Note; I cannot filter at the time of loading bcoz I am using rest of the value in other screen.

[sushil353]

Hi,

in the list box properties>General>field> select expression

=if(country='India' or country='UK',country,null())

HTH

Sushil

[Anil_Babu_Samineni]

You can try using Expression of List box

=If(Country='India','ÚK',Country)

Try This

=If(WildMatch(Country, 'India','UK'),Country)

[leni_harishwara]

Create a listbox and choose expression in that and type as below,

If(MixMatch(Country,'India','UK'),Country)

Regards,

Leni

[Anonymous]

hi

in the expression you can write this

=if(match(Country,'India','UK'),country )

[sunny_talwar]

You can also try this:

Aggr(Only({<Country = {'India', 'UK'}>} Country), Country)

[Anonymous]

I'd still recommend to do it in the script.  But, instead filtering the Country field, create an additional field (e.g. "Country Short List") with India and UK only.  It would simplify front end and improve performance.