Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

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
petter
Partner - Champion III
Partner - Champion III

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 )

View solution in original post

2 Replies
petter
Partner - Champion III
Partner - Champion III

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 )

Chanty4u
MVP
MVP

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 )