Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

nacho_duque
New 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
Valued Contributor

Re: counting people Quartile

Hi Jose,

Maybe something like this:

fractile(Count(Usuario), 0.25)




Re: counting people Quartile

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

Community Browser