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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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,