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: 
gerrycastellino
Creator III
Creator III

issue with count, set analysis, modifier

This statement does not seem to work with the modifier:

I'm looking for the difference between 2 states with the modifier (default and Exclusion)

Count( {$-Exclusion} DISTINCT {< account_uuid = {"*"}>} contact_uuid)

If I remove the modifier,  I'm getting a correct total.

Count( {$-Exclusion} DISTINCT contact_uuid)

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Do you want this:

Count({$-Exclusion <account_uuid = {"*"}>} DISTINCT contact_uuid)

or

Count({$<account_uuid = {"*"}> - Exclusion <account_uuid = {"*"}>} DISTINCT contact_uuid)

View solution in original post

1 Reply
sunny_talwar
MVP
MVP

Do you want this:

Count({$-Exclusion <account_uuid = {"*"}>} DISTINCT contact_uuid)

or

Count({$<account_uuid = {"*"}> - Exclusion <account_uuid = {"*"}>} DISTINCT contact_uuid)