Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
ID | Spend |
1234 | $10 |
1234 | $10 |
1234 | $10 |
5678 | $10 |
7890 | $10 |
=Count(Distinct Field)
May be this:
Count(DISTINCT ID)
=Count(Distinct Field)
Count(Distinct Field)
Where to add "Count(Distinct Field)" as there is not "Expression tab" in Qlikview Statistics Box.