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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

proper syntax for distinct count

I need to do a distinct count of Rx# when Refill# = 0. Here's my expression so far...

Count({$<[RX#]=P({1<[Refill#]={0}>}[RX#])>}[RX#])

How do you tweak this to include a distinct count of RX#?

I'm failing at figuring this one out.

Thank you.

3 Replies
vinafidalgo
Partner - Creator
Partner - Creator

Try this:

Count(Distinct {$<[Refil#]={0}>}[RX#])

Clever_Anjos
Employee
Employee

DISTINCT clause must precede you Set Analysis expression

Not applicable
Author

Thank you Vinivius!