Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

gerrycastellino
Contributor 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)

Tags (1)
1 Solution

Accepted Solutions

Re: issue with count, set analysis, modifier

Do you want this:

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

or

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

1 Reply

Re: issue with count, set analysis, modifier

Do you want this:

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

or

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