Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted
MVP & Luminary
MVP & Luminary