Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.