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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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)

1 Solution

Accepted Solutions
sunny_talwar

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

Do you want this:

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

or

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