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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.