Getting the top 10% of a list

[Anonymous]

Hi all,

I have been asked to provide a list of the top 10% of patients that have been waiting longest on our list.

But am not sure how you would do this in Qlikview.  is it a case of counting how many rows there are in the list, then perform a rank on each row and only show those in the top 10%?

I've attached a simple qvw file but haven't got anything like a solution just yet.

Look forward to hearing from you.

Thanks,

John.

[Anonymous · Accepted solution]

Yikes,

no sooner did I post this than I found a solution to a similar problem - thanks John Whitherspoon.  I swear I searched this community high and low but couldn't find anything close.

Here is the solution John provided.

=SUM({$<WaitingTimeAtCensusDate ={">=$(=fractile(WaitingTimeAtCensusDate,.9))"}>} WaitingTimeAtCensusDate)

in other words, compare each waiting time to the top 10%.

[eliran]

Hi John,

First of all, you can sort the list by using the sum function and making it descending

sum

(WaitingTimeAtCensusDate)

Another option is to make a chart, where the PersonIdentifier is the dimension and the expression is the same sum function above.

About the max 10%, it depends on what version of qlikview do you use.

In version 11 you have built in option to select top 10%.

Hope it helps,

Eliran.