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: 
trang_dinh_ral
Contributor
Contributor

#KPI: How can I count value without duplication.

I have a column like this. I want to count to know how many value in this column without duplication.


Please let me know how can I do it.

Thank you very much.

Capture.PNG

2 Replies
vitaliichupryna
Creator III
Creator III

Hi Dinh,

You can use distinct, so you calculation should looks like:

Count(Distinct Your_Column)

Thanks,

Vitalii

trang_dinh_ral
Contributor
Contributor
Author

It works.

Thank you so much.