Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NelsonDiazDean01
Contributor II
Contributor II

Count() of a count() column

Hello...

Have an issue with a set analysis.

NelsonDiazDean01_0-1595338613321.png

What I need is the number of repetitions of 1's, 2's, etc...

Would be owesome if that could be in a table...

How many 1, how many 2, and so on...

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Calculated dimension : =Aggr(Count(IdDesc), IdDesc)

Exp : =Count(Aggr(Count(IdDesc), IdDesc))

 

Note : Change the dimension name.

View solution in original post

3 Replies
tresesco
MVP
MVP

Calculated dimension : =Aggr(Count(IdDesc), IdDesc)

Exp : =Count(Aggr(Count(IdDesc), IdDesc))

 

Note : Change the dimension name.

NitinK7
Specialist
Specialist

Hi

check once using AGGR

like

Aggr( count (fieldname), fieldname)

NelsonDiazDean01
Contributor II
Contributor II
Author

Fits perfect.! Thanks.!