Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have this data in Qlik Sense
Name | COUNT(value) |
---|---|
Jeff | 4 |
Joseph | 4 |
Juan | 3 |
Orlando | 2 |
... | ... |
And I want to get what number of items have 4 count(value), 3, 2, ....etc.
So for the example is:
COUNT(value) | Number of items |
---|---|
4 | 2 |
3 | 1 |
2 | .... |
How can I do that? Thanks!
Like using a dimension
=Aggr( Count(value), Name)
with an expression
=Count(DISTINCT Name)
Like using a dimension
=Aggr( Count(value), Name)
with an expression
=Count(DISTINCT Name)
May be like this
Dimension
Aggr(Count(value), Name)
Expression
Count(DISTINCT Name)