Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nacho_duque
Contributor III
Contributor III

counting people Quartile

Hello good day,

I have a table that calculate quartiles and need to know the people who are within each quartile

The formula quartile is:

fractile( aggr( avg(PuntacionNota), Usuario), 0.25)

Captura.PNG

2 Replies
andrespa
Specialist
Specialist

Hi Jose,

Maybe something like this:

fractile(Count(Usuario), 0.25)




sunny_talwar

This I think won't work without adding an Aggr() function because both Fractile and Count are aggregations