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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
tresB
Champion III
Champion III

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

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

 

Note : Change the dimension name.

View solution in original post

3 Replies
tresB
Champion III
Champion III

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.!