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: 
Not applicable

distinct count

count({$<MOD = {'X4','X5','X6','X3','X7'},CPT -={'99499'}>}[MRN])







I have the above formula but its not distinct. The MRN count is adding dups as well. How can i make it distinct.

Thanks

Krishan

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

Just add the word "distinct": count({your set} distinct MRN)

Regards,

View solution in original post

1 Reply
vgutkovsky
Master II
Master II

Just add the word "distinct": count({your set} distinct MRN)

Regards,