Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis exclusion on all fields from a particular table

Hi there,

Bit new to the Set Analysis. I would very much like to know if there is a simple way to exclude selections in an expression from an entire table? Is this possible?

Kind regards

Jonathan

4 Replies
Not applicable
Author

HI Jonathan,

You can exclude something in Set analysis by using the - sign

for example:

SUM(

     {<

          Dimension -= {'Value'}

     >}

     Sales

)

Regards,

Reyman

swarup_malli
Specialist
Specialist

Jonathan,

I'm attaching an example(.qvw).

Regards

Swarup

SunilChauhan
Champion II
Champion II

sum({1-$}value)

will sum all values exceept current selections

$ represent current selection

hope this helps you

Sunil Chauhan
Not applicable
Author

Hi everyone, thanks for the help and sorry for the late reply. What I was refering to would be to exclude any selections made on any dimensions in a whole table. Would I have to enter all the fields one at a time?

Thanks again for all the help