Count number of items with specific measure value

[josecanalla]

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!

[swuehl · Accepted solution]

Like using a dimension

=Aggr( Count(value), Name)

with an expression

=Count(DISTINCT Name)

[sunny_talwar]

May be like this

Dimension

Aggr(Count(value), Name)

Expression

Count(DISTINCT Name)