Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Top N PERCENTAGE(%) performers/users.

Hi folks,

How do you - get the results of N percentage users?

I know there is a rank function but if am not mistaken you can only derive using exact figures from it, e.g. (if(rank(sum(SALES))<=10) but what I want to know is how can I do so but using percentage? e.g. finding Top 20% performers, Median 30%, BTM 50%?

Please advise. Thanks in advance.

Best Regards,

R

1 Reply

Re: Top N PERCENTAGE(%) performers/users.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis

You can also use Dimension Limit

Third Option

Show only values that accumulate to ....

Community Browser