Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to calculate Top/Bottom Quartile of a column

Hello,

Urgent!

Could you please tell me how do I calculate Top/Bottom Quartile of a column in a pivot table.

Any input/suggestions are highly appreciated. Thanks.

4 Replies

Re: How to calculate Top/Bottom Quartile of a column

Use Fractile function:

Fractile(FieldName, 0.25) -> For 1st Quartile

Fractile(FieldName, 0.75) -> For 3rd Quartile

Not applicable

Re: How to calculate Top/Bottom Quartile of a column

Thanks much for prompt response Sunny.

Actually, FieldName I have is "Sum(Meetings)". If I put like this Fractile(Sum(Meetings), 0.25), its giving me an error saying nested aggregate functions are not allowed.

I tried using master items but no luck.

Moreover, I am trying to identify what is bottom or top quartile of a Meetings field and shade red for bottom and green for top quartiles.

Can you please guide me thru how to achieve this.

reddys310
Honored Contributor II

Re: How to calculate Top/Bottom Quartile of a column

HI Kishore,

As Sunny mentioned the fractile() should help you. Also check these out.

Re: Fractile with Calculated Field??

Thanks,

Sangram.

Re: How to calculate Top/Bottom Quartile of a column

You would need a Aggr function between your Fractile and Sum functions:

Fractile(Aggr(Sum(Meetings), AggregatingFieldsHere), 0.25)

Community Browser