Exclude every filter except one

[manideep78]

Dear Community,

Is there a way that I can exclude all other filters except one in expression.

Note: If I have many columns I cannot write like this in expression {<date=, day=,>}. I have to stop all the remaining filters except one filer say like Year.

[giakoum]

Add this in your set expression :

$(=Concat({1<$Field-={'Year'}>} '[' & $Field & ']',','))

[Gysbert_Wassenaar]

{1<Year=P(Year)>}

See also this document: Ignore all selections except some specific fields using Set Analysis

[luciancotea]

One way is to write the whole string in a variable, then use the variable in the expressions.

[mrossoit]

Maybe you could find something interesting here http://community.qlik.com/message/16196#16196

[manideep78]

Thanks everyone for replies. Alternate state solved my problem