topic Ranking Top Sales Person in QlikView https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235045#M86335 <HTML><HEAD></HEAD><BODY><P>I'm trying to rank inside the expression only the top person with ignoring the selections..</P></BODY></HTML> Tue, 10 Nov 2009 02:10:16 GMT 2009-11-10T02:10:16Z Ranking Top Sales Person https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235043#M86333 <HTML><HEAD></HEAD><BODY><P>I would the ability to rank the top Sales Person and show as an Expression in the report. So that the individual Sales Person can see how they rank to the top Sales Person.</P><P>Any Help would be greatly appreciated. Qlikview Example attached.</P><P>Thanks</P></BODY></HTML> Sat, 07 Nov 2009 04:53:03 GMT https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235043#M86333 2009-11-07T04:53:03Z Ranking Top Sales Person https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235044#M86334 <HTML><HEAD></HEAD><BODY><P>Scott,</P><P>in order to rank by an expression (like sum(Sales)), you don't need anything fancy - just use function rank():</P><P>rank(sum(Sales))</P><P>I'm not sure I understand what were you trying to do with the expressions in your example...</P><P></P><P></P><DIV id="refHTML"></DIV></BODY></HTML> Sat, 07 Nov 2009 05:44:39 GMT https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235044#M86334 Oleg_Troyansky 2009-11-07T05:44:39Z Ranking Top Sales Person https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235045#M86335 <HTML><HEAD></HEAD><BODY><P>I'm trying to rank inside the expression only the top person with ignoring the selections..</P></BODY></HTML> Tue, 10 Nov 2009 02:10:16 GMT https://community.qlik.com/t5/QlikView/Ranking-Top-Sales-Person/m-p/235045#M86335 2009-11-10T02:10:16Z