topic Exclude all but ... in QlikView

Exclude all but ...

Fri, 16 May 2014 19:42:54 GMT

I have another probably simple question, thank you in advance for your help. I pasted my code below. What I am doing is summing the counts on what has been filtered excluding the three filters 1_1, 1_2, and 1_3. But I have 50 filters, and will probably add more in the future, that I want to exclude. And there are three filters I always want to include. Call them Time, Place and Person. So how do I code the same thing below to exclude all but Time, Place, and Person? Thank you.

sum(total{<1_1=, 1_2=, 1_3=>} Count)

Re: Exclude all but ...

Fri, 16 May 2014 19:45:23 GMT

Use Sum({1<Time=, Place=,Person=>} Count)

This will consider entire memory respecting the selections for Time Place and Person.

Re: Exclude all but ...

Fri, 16 May 2014 20:02:45 GMT

This doesn't appear to work. It seems to be excluding all filters giving me the same answer as simply

sum(total Count) . Thanks for the attempt though.