Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.!