topic Re: Rank Function in QlikView https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789434#M279168 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>Add - before Sum</P><P>aggr(rank(-sum({&lt;[RISK STATE]=&gt;}[NET WRITTEN PREMIUM]),4),[RISK STATE]).</P></BODY></HTML> Wed, 11 Feb 2015 21:01:40 GMT robert_mika 2015-02-11T21:01:40Z Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789433#M279167 <HTML><HEAD></HEAD><BODY><P>I am using the following function to rank different metrics by state:</P><P>aggr(rank(sum({&lt;[RISK STATE]=&gt;}[NET WRITTEN PREMIUM]),4),[RISK STATE]).</P><P></P><P>My question is how to inverse the order.&nbsp; I have several ratio metrics where the lowest number would actually be the best versus the normal sales and premiums where the highest number is best.</P><P></P><P>Thank you for the help,</P><P></P><P>Justin</P></BODY></HTML> Wed, 11 Feb 2015 20:31:39 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789433#M279167 Anonymous 2015-02-11T20:31:39Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789434#M279168 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>Add - before Sum</P><P>aggr(rank(-sum({&lt;[RISK STATE]=&gt;}[NET WRITTEN PREMIUM]),4),[RISK STATE]).</P></BODY></HTML> Wed, 11 Feb 2015 21:01:40 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789434#M279168 robert_mika 2015-02-11T21:01:40Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789435#M279169 <HTML><HEAD></HEAD><BODY><P>Great thank you for the help.</P></BODY></HTML> Wed, 11 Feb 2015 21:06:17 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789435#M279169 Anonymous 2015-02-11T21:06:17Z Re: Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789436#M279170 <HTML><HEAD></HEAD><BODY><P>You are welcome</P></BODY></HTML> Wed, 11 Feb 2015 21:17:52 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/789436#M279170 robert_mika 2015-02-11T21:17:52Z