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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

Labels (1)
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,