topic Re: counting people Quartile in QlikView

counting people Quartile

nacho_duque — Fri, 04 Mar 2016 09:44:58 GMT

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)

andrespa — Fri, 04 Mar 2016 14:00:18 GMT

Hi Jose,

Maybe something like this:

fractile(Count(Usuario), 0.25)

sunny_talwar — Fri, 04 Mar 2016 14:06:26 GMT

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