topic Re: Filter Values In List box in QlikView

Filter Values In List box

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

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

Country

India

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.

Re: Filter Values In List box

sushil353 — Thu, 20 Oct 2016 06:27:20 GMT

Hi,

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

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

HTH

Sushil

Re: Filter Values In List box

Anil_Babu_Samineni — Thu, 20 Oct 2016 06:28:59 GMT

You can try using Expression of List box

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

Try This

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

Re: Filter Values In List box

leni_harishwara — Thu, 20 Oct 2016 06:48:27 GMT

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

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

Regards,

Leni

Re: Filter Values In List box

Anonymous — Thu, 20 Oct 2016 06:48:57 GMT

in the expression you can write this

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

Re: Filter Values In List box

sunny_talwar — Thu, 20 Oct 2016 09:26:30 GMT

You can also try this:

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

Re: Filter Values In List box

Anonymous — Thu, 20 Oct 2016 13:36:17 GMT

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.