Percentile

[Anonymous]

Hi Everyone,

I was wondering if anyone could help please.

I need to create a Qlik View file which calculates the Percentile of the values.

I have attached an Excel spreadsheet which shows the Percentile formulas.  Basically if you filter on the Reference the Formula calculates what Percentage each rows value is against the overall for the year so far.

I would like Qlik View to work out this calculation for me, then I can create some buttons which will allow me to show 5%, 95% then everything in between i.e. 5% to 95%.

If anyone can advise me the best way to approach this I would much appreciate it.

Many Thanks

Kind Regards

Wendy

[abhijith28]

Hi,

what changes has to be done, if i need the percentile of each value regardless of the Ref i.e. A and B.

Thank you,