topic Re: Negative value in Rank in QlikView https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901781#M1006157 <HTML><HEAD></HEAD><BODY><P>Bottom 20. I.e. 20 salesmen who performed worst (minimum sales). </P></BODY></HTML> Thu, 21 May 2015 05:11:16 GMT tresB 2015-05-21T05:11:16Z Negative value in Rank https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901779#M1006155 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Could anyone explain what does this formula do?</P><P></P><P><SPAN style="color: #000080;">=If(Aggr(Rank(-Sum(Sales)) &lt;= 20,Salesman),Salesman)</SPAN></P><P></P><P>Thanks in advance.</P></BODY></HTML> Thu, 21 May 2015 05:00:41 GMT https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901779#M1006155 qlikviewwizard 2015-05-21T05:00:41Z Re: Negative value in Rank https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901780#M1006156 <HTML><HEAD></HEAD><BODY><P>I think it shows the top 20 Salesmen (e.g. as Dimension)&nbsp;&nbsp; based on their sum of sales but also based on an inverse ranking of sales (so last rank becomes first rank)</P></BODY></HTML> Thu, 21 May 2015 05:09:43 GMT https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901780#M1006156 danieloberbilli 2015-05-21T05:09:43Z Re: Negative value in Rank https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901781#M1006157 <HTML><HEAD></HEAD><BODY><P>Bottom 20. I.e. 20 salesmen who performed worst (minimum sales). </P></BODY></HTML> Thu, 21 May 2015 05:11:16 GMT https://community.qlik.com/t5/QlikView/Negative-value-in-Rank/m-p/901781#M1006157 tresB 2015-05-21T05:11:16Z