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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Spartan27215
Partner - Creator
Partner - Creator

How to exclude

How do I go about doing this...

1. I have a Dollar amount as a measure

2. I have A certification as a dimension.

I want to compare the Dollars for having the certification vs not having the certification. 

The easy part is Has the Certification...

<$<Certification={'Cert A'}>} DollarAmount

The question is how to do this to get the opposite? Note the below does not work

<$<Certification={'<>Cert A'}>} DollarAmount

 

Labels (2)
1 Solution

Accepted Solutions
2 Replies
BrunPierre
Partner - Master II
Partner - Master II

vinieme12
Champion III
Champion III

As below

=sum({$-<Certification={'Cert A'}>} DollarAmount)

or 

=sum({<Certification-={'Cert A'}>} DollarAmount)

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.