Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Quartile analysis

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

2 Replies
sunny_talwar

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

jagan
Luminary Alumni
Luminary Alumni