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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unique count for Statistics Box

How can I get a unique count? I tried the Statistics box but this gave me a total count. I have a customer ID and their spend. Looking at the chart below, I just want to see how many unique customers I have. For example, below would be 3 unique customers (1234, 5678. 7890). I don't need their spend, just a count of how many customers.

 

IDSpend
1234$10
1234$10
1234$10
5678$10
7890$10
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

=Count(Distinct Field)

View solution in original post

4 Replies
sunny_talwar

May be this:

Count(DISTINCT ID)

Chanty4u
MVP
MVP

=Count(Distinct Field)

Not applicable
Author

Count(Distinct Field)

Anonymous
Not applicable
Author

Where to add "Count(Distinct Field)" as there is not "Expression tab" in Qlikview Statistics Box.