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: 
thomas_2583
Contributor III
Contributor III

Count Distinct with Criteria

Hi, 

I have this measure: count (distinct TRN)

I need to add in: if BOX = 'Plastic' into the criteria above, how do I do this please?

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

May be this?

count ({<BOX={'Plastic'}>}distinct TRN)

View solution in original post

1 Reply
Chanty4u
MVP
MVP

May be this?

count ({<BOX={'Plastic'}>}distinct TRN)