Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

josecanalla
New Contributor III

Count number of items with specific measure value

Hello, I have this data in Qlik Sense

NameCOUNT(value)
Jeff4
Joseph4
Juan3
Orlando2
......

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
42
31
2....

How can I do that? Thanks!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Count number of items with specific measure value

Like using a dimension

=Aggr( Count(value), Name)

with an expression

=Count(DISTINCT Name)

2 Replies
MVP
MVP

Re: Count number of items with specific measure value

Like using a dimension

=Aggr( Count(value), Name)

with an expression

=Count(DISTINCT Name)

Re: Count number of items with specific measure value

May be like this

Dimension

Aggr(Count(value), Name)

Expression

Count(DISTINCT Name)

Community Browser