Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude all but ...

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

2 Replies
Not applicable
Author

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

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

Not applicable
Author

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.