topic Re: Quartile analysis in QlikView

Quartile analysis

Wed, 02 Mar 2016 23:16:43 GMT

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 — Thu, 03 Mar 2016 01:09:14 GMT

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

jagan — Thu, 03 Mar 2016 02:12:13 GMT

Hi,

Chect this link