topic Top N PERCENTAGE(%) performers/users. in QlikView https://community.qlik.com/t5/QlikView/Top-N-PERCENTAGE-performers-users/m-p/589250#M681056 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>How do you - get the results of N percentage users?</P><P></P><P>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))&lt;=10) but what I want to know is how can I do so but using percentage? e.g. finding <STRONG>Top 20% performers, Median 30%, BTM 50%?</STRONG></P><P></P><P>Please advise. Thanks in advance.</P><P></P><P>Best Regards,</P><P>R</P></BODY></HTML> Thu, 17 Apr 2014 08:42:41 GMT 2014-04-17T08:42:41Z Top N PERCENTAGE(%) performers/users. https://community.qlik.com/t5/QlikView/Top-N-PERCENTAGE-performers-users/m-p/589250#M681056 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>How do you - get the results of N percentage users?</P><P></P><P>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))&lt;=10) but what I want to know is how can I do so but using percentage? e.g. finding <STRONG>Top 20% performers, Median 30%, BTM 50%?</STRONG></P><P></P><P>Please advise. Thanks in advance.</P><P></P><P>Best Regards,</P><P>R</P></BODY></HTML> Thu, 17 Apr 2014 08:42:41 GMT https://community.qlik.com/t5/QlikView/Top-N-PERCENTAGE-performers-users/m-p/589250#M681056 2014-04-17T08:42:41Z Re: Top N PERCENTAGE(%) performers/users. https://community.qlik.com/t5/QlikView/Top-N-PERCENTAGE-performers-users/m-p/589251#M681057 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis">http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis</A></P><P></P><P>You can also use Dimension Limit </P><P>Third Option</P><P>Show only values that accumulate to ....</P></BODY></HTML> Thu, 17 Apr 2014 08:58:38 GMT https://community.qlik.com/t5/QlikView/Top-N-PERCENTAGE-performers-users/m-p/589251#M681057 MK_QSL 2014-04-17T08:58:38Z