Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can calculate quartile using Fractile() function, but how would you group the branches?