Is there anyway to exclude filter selections other than "=" in the Set Analysis

[Anonymous]

I want to exclude all filter selections apart from month. Given that i have a lot of variables and a lot of script manually typing in for each vairable e.g. (sum({<Statement={'I consider myself a car enthusiast'},Response_Invlovement={'Agree'},Age=,Gender=,.....>} total WGT)) is becoming very cumbersome. Is there a way to exclude all possible selections other than my month variable? I cant manually type in all the variables because of Qlik's character limitation.

[jonathandienst]

Use syntax like this:

Sum({1<

    Statement={'I consider myself a car enthusiast'},

    Response_Invlovement={'Agree'},

    Month = $::Month

>} total WGT))

The {1} set will ignore all selections except for Statement and Response (explicitly defined) and Month (using selection). All other selections are ignored.

(assumes Month is a field not a variable)

[Anonymous]

Hey Thanks Jonathan ,

When i do that however the filter pane for month becomes empty. I want to be able to still select certain month/s. Also how do i undo making month a field instead of variable?

Cheers,

David

[Neymar_Jr]

Hi,

Try this -

Sum({1<

    Statement={'I consider myself a car enthusiast'},

    Response_Invlovement={'Agree'},

    Month=P(Month)

>} total WGT))

Thanks,

RT

[sunny_talwar]

Also, look here

Ignore all selections except few fields using Set Analysis

[Anonymous]

Thanks Sunny thats really helpful