Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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!