Can I apply a set expression to a filter pane?

[rvijayanth]

Can I apply a set expression to a filter pane?

I have a country column and continent column:

I want to use Country as a filter but only show Countries from ASIA. Is it possible?

[trdandamudi · Accepted solution]

In a list box expression you can use any one of the expression:

=Aggr(Only({<Continent = {'Asia'}>} Country), Country)

OR

=If(MixMatch(Continent,'Asia'),Country)

[Anil_Babu_Samineni]

What set expression you are going with? I mean which aggregate needed? Read this Set analysis and set expressions ‒ QlikView

[rvijayanth]

This is exactly what Im looking for but I forgot to mention it is in QlikSense. Is this possible in QlikSense?

[trdandamudi]

I do not have Qliksense, but you can give a try. I think it might work...

[sunny_talwar]

I think it should... I don't see why it wouldn't

[rvijayanth]

It worked. Thanks everyone.

Btw I used =If(MixMatch(Continent,'Asia'),Country)