Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Set Modifier Not Equal to

Hello,

I have the following expression :

Count({<CPT_CATEGORY != {'Product Sales'}, CPT != {'96567','96920','96922'}>}Distinct Visits)

Where I am trying to count distinct visits that are not product sales and not service code {'96567','96920','96922'}... but it says there is an error in the set modifier expression.

Thanks in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Set Modifier Not Equal to

The = means "selection assignment" it does not mean equal to.

What should give you the result you are looking for is this:

Count({<CPT_CATEGORY=-{'Product Sales'}, CPT=-{'96567','96920','96922'}>} Distinct Visits )

2 Replies
MVP
MVP

Re: Set Modifier Not Equal to

The = means "selection assignment" it does not mean equal to.

What should give you the result you are looking for is this:

Count({<CPT_CATEGORY=-{'Product Sales'}, CPT=-{'96567','96920','96922'}>} Distinct Visits )

sureshqv
Esteemed Contributor III

Re: Set Modifier Not Equal to

try this

Count({<CPT_CATEGORY/={'Product Sales'}, CPT/={'96567','96920','96922'}>} Distinct Visits )


or


Count({<CPT_CATEGORY-={'Product Sales'}, CPT-={'96567','96920','96922'}>} Distinct Visits )

Community Browser