topic Re: How to Create rank on Calucalted column. in QlikView https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654671#M239193 <HTML><HEAD></HEAD><BODY><P>try like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Rank(sum({&lt;[Manager Name Lvl 03]={'dimm'}&gt;}&nbsp; Amount)) </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">OR </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Rank( <SPAN style="font-size: 18pt; font-family: calibri, verdana, arial, sans-serif;">-</SPAN> sum({&lt;[Manager Name Lvl 03]={'dimm'}&gt;}&nbsp; Amount))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">minus sign to show rank in reverse order....<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Tue, 26 Aug 2014 16:58:49 GMT israrkhan 2014-08-26T16:58:49Z How to Create rank on Calucalted column. https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654670#M239192 <HTML><HEAD></HEAD><BODY><P>Hi i want to show rank for calculated coumn</P><P></P><P>i created one expression for total::::::</P><P> sum({&lt;[Manager Name Lvl 03]={'dimm'}&gt;}&nbsp; Amount)</P><P>its giving sum total like below</P><P></P><P>manger&nbsp;&nbsp; AMOUNT</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P></P><P>Now i want display rank also</P><P></P><P>manager&nbsp;&nbsp;&nbsp;&nbsp; amount&nbsp; rank</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3</P><P>b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P>c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P></BODY></HTML> Tue, 26 Aug 2014 16:39:42 GMT https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654670#M239192 2014-08-26T16:39:42Z Re: How to Create rank on Calucalted column. https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654671#M239193 <HTML><HEAD></HEAD><BODY><P>try like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Rank(sum({&lt;[Manager Name Lvl 03]={'dimm'}&gt;}&nbsp; Amount)) </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">OR </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Rank( <SPAN style="font-size: 18pt; font-family: calibri, verdana, arial, sans-serif;">-</SPAN> sum({&lt;[Manager Name Lvl 03]={'dimm'}&gt;}&nbsp; Amount))</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">minus sign to show rank in reverse order....<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Tue, 26 Aug 2014 16:58:49 GMT https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654671#M239193 israrkhan 2014-08-26T16:58:49Z Re: How to Create rank on Calucalted column. https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654672#M239194 <HTML><HEAD></HEAD><BODY><P>its giving 1,1,1,1,1</P><P></P><P>its not giving exact output</P></BODY></HTML> Tue, 26 Aug 2014 17:06:38 GMT https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654672#M239194 2014-08-26T17:06:38Z Re: How to Create rank on Calucalted column. https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654673#M239195 <HTML><HEAD></HEAD><BODY><P>it must work...</P><P>can you please share a sample document...i can help you in better way..</P></BODY></HTML> Tue, 26 Aug 2014 17:09:36 GMT https://community.qlik.com/t5/QlikView/How-to-Create-rank-on-Calucalted-column/m-p/654673#M239195 israrkhan 2014-08-26T17:09:36Z