topic Re: Exclude every filter except one in QlikView

Exclude every filter except one

manideep78 — Fri, 20 Mar 2015 15:15:36 GMT

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.

Re: Exclude every filter except one

giakoum — Fri, 20 Mar 2015 15:20:07 GMT

Add this in your set expression :

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

Re: Exclude every filter except one

Gysbert_Wassenaar — Fri, 20 Mar 2015 15:20:22 GMT

{1<Year=P(Year)>}

Re: Exclude every filter except one

luciancotea — Fri, 20 Mar 2015 15:21:13 GMT

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

Re: Exclude every filter except one

mrossoit — Fri, 20 Mar 2015 15:24:32 GMT

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

Re: Exclude every filter except one

manideep78 — Fri, 20 Mar 2015 15:46:58 GMT

Thanks everyone for replies. Alternate state solved my problem