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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
BrunPierre
Partner - Master II
Partner - Master II

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.