How to Calculate 80th percentile and translate it ... - Qlik Community

Keitaru · ‎2019-03-26

Hi need some help,

I'm trying to calculate and display 80th percentile with my bar chart below.

I've attached the dummy data

Been trying to use to figure out how to do a 80 20 rule against count with Fractile(), however haven't seem to figure out how to get it to work.

fractile(Count (Total [ID])), .8)

So my End Result I wish to Achieve something like this.

Mauritz_SA · ‎2019-03-26

Hi there

I haven't done it before, but I can see that it might become a business request in future so I decided to look around. Try something this:

I know it is in QlikView, but the principles stay the same.

Regards,

Mauritz

Lucke_Hallbergson · ‎2019-03-26

Hi,

An example app with Pareto colouring in a barchart and Pareto colouring in a combochart is attached;

Best Regards

Lucke

Lucke_Hallbergson · ‎2019-03-26

You might want to have a look at this article as well;

How to Calculate 80th percentile and translate it to Bar Chart