topic Re: Percentile Rank calculation in Water Cooler

Percentile Rank calculation

Tue, 28 May 2013 19:19:20 GMT

I need to calculate the percentile rank function on the fly in QV app., example see attached excel file, anyone knows how?

Re: Percentile Rank calculation

rustyfishbones — Tue, 28 May 2013 19:27:33 GMT

Maybe this video will help

http://www.youtube.com/watch?v=KCPKNYWmb5g

Or this video

http://www.youtube.com/watch?v=MypobUg-HkE

Re: Percentile Rank calculation

Thu, 30 May 2013 14:57:31 GMT

Thanks for sharing the video. But this is showing the rank only. How can I show a rank in percentile fashion? For example, I need to count how many items are within 10,20,30, 50, 90, and 95 percentile respectively. What is the equivalent function of Excel Percent Rank function in Qlikview?

Re: Percentile Rank calculation

phcaptjim — Tue, 18 Feb 2014 01:19:09 GMT

I have a need for this same functionality.

Basically I have a list of patients and I sum up their charges based on the selections the user has made, so this calculation must be done on the fly. This is tricky, but I am sure there is a way to accomplish this in QVW.

Re: Percentile Rank calculation

Fri, 24 Oct 2014 23:30:10 GMT

I think I figured out one way to do it...Let's say you have 2 dimensions (Dimension1 and Dimension2) and 1 expression (vExpression) in your straight table, the code would be...

Rank(TOTAL -$(vExpression)) /

Count(TOTAL aggr($(vExpression), [Dimension1],[Dimension2]))

You may need to modify slightly for your specific example. My guess is something like...

Rank(TOTAL -[Citation Counts]) /

Count(TOTAL aggr([Citation Counts], [Journal],[Year Published],[Document Type],[Year Cited]))

Hope that helps.