Quartile analysis

[#1]

Hi,

I need to develop a Qlik dashboard that allow user to analyze data by quartile.

E.g. I have some dimensions and one are branches. I need to evaluate a KPI, let's say A/B, and define in which quartile a specific branch is located.

So, if my data in input is:

Branch, A, B,

x, 6, 5

y, 5, 4

z, 6, 4

f, 4, 3

g, 6, 2

h, 5, 2

My output need to group my branches in 4 quartile, with the rule (0.25, 0.5, 0,75. 1)

Thanks

[sunny_talwar]

You can calculate quartile using Fractile() function, but how would you group the branches?

[jagan]

Hi,

Chect this link

Fractile / Quartile in pivot table dimension

Re: Quartile