topic Ranking in QlikView https://community.qlik.com/t5/QlikView/Ranking/m-p/850567#M469377 <HTML><HEAD></HEAD><BODY><P>Hi Experts.....</P><P>i want to give a proper ranking to expression...<BR />i had used rank 1,1 format...<BR />m getting following output..</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD height="20" width="64">value</TD><TD width="111">rank((value),1,1)</TD></TR><TR><TD align="right" height="20">10</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">30</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">40</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">60</TD><TD align="right">9</TD></TR><TR><TD align="right" height="20">80</TD><TD align="right">10</TD></TR></TBODY></TABLE><P></P><P>expected output</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD height="20" width="64">value</TD><TD width="111">Expected_rank</TD></TR><TR><TD align="right" height="20">10</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">30</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">40</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">60</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">80</TD><TD align="right">7</TD></TR></TBODY></TABLE><P></P><P></P><P>plz Help me..<BR />thanks in advance...</P></BODY></HTML> Fri, 10 Jul 2015 11:10:36 GMT prajapatiamar38 2015-07-10T11:10:36Z Ranking https://community.qlik.com/t5/QlikView/Ranking/m-p/850567#M469377 <HTML><HEAD></HEAD><BODY><P>Hi Experts.....</P><P>i want to give a proper ranking to expression...<BR />i had used rank 1,1 format...<BR />m getting following output..</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD height="20" width="64">value</TD><TD width="111">rank((value),1,1)</TD></TR><TR><TD align="right" height="20">10</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">30</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">40</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">60</TD><TD align="right">9</TD></TR><TR><TD align="right" height="20">80</TD><TD align="right">10</TD></TR></TBODY></TABLE><P></P><P>expected output</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="175"><TBODY><TR><TD height="20" width="64">value</TD><TD width="111">Expected_rank</TD></TR><TR><TD align="right" height="20">10</TD><TD align="right">1</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">20</TD><TD align="right">2</TD></TR><TR><TD align="right" height="20">30</TD><TD align="right">3</TD></TR><TR><TD align="right" height="20">40</TD><TD align="right">4</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">50</TD><TD align="right">5</TD></TR><TR><TD align="right" height="20">60</TD><TD align="right">6</TD></TR><TR><TD align="right" height="20">80</TD><TD align="right">7</TD></TR></TBODY></TABLE><P></P><P></P><P>plz Help me..<BR />thanks in advance...</P></BODY></HTML> Fri, 10 Jul 2015 11:10:36 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/850567#M469377 prajapatiamar38 2015-07-10T11:10:36Z Re: Ranking https://community.qlik.com/t5/QlikView/Ranking/m-p/850568#M469378 <HTML><HEAD></HEAD><BODY><P>Try,</P><P></P><P>Expression - Rank( Total sum(Value))</P></BODY></HTML> Fri, 10 Jul 2015 11:15:43 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/850568#M469378 Kushal_Chawda 2015-07-10T11:15:43Z Re: Ranking https://community.qlik.com/t5/QlikView/Ranking/m-p/850569#M469379 <HTML><HEAD></HEAD><BODY><P>i had used the same expression...<BR />but not giving output with the same.....</P></BODY></HTML> Fri, 10 Jul 2015 11:24:48 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/850569#M469379 prajapatiamar38 2015-07-10T11:24:48Z Re: Ranking https://community.qlik.com/t5/QlikView/Ranking/m-p/850570#M469380 <HTML><HEAD></HEAD><BODY><P>Maybe like attached.</P></BODY></HTML> Fri, 10 Jul 2015 11:26:45 GMT https://community.qlik.com/t5/QlikView/Ranking/m-p/850570#M469380 swuehl 2015-07-10T11:26:45Z