topic Rank and sort in QlikView

topic Rank and sort in QlikView https://community.qlik.com/t5/QlikView/Rank-and-sort/m-p/39251#M6613 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">From below table can anyone suggest how to get rank column when the values are same and then arrange the rank by alphabetical order based on ID column.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="144" style="width: 383px; height: 130px;"><TBODY><TR><TD class="xl73" height="17" width="141"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">MeterNo</SPAN></TD><TD class="xl65" style="border-left: none;" width="98"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Rank</SPAN></TD><TD class="xl74" style="border-left: none;" width="98"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">ID</SPAN></TD><TD class="xl66" width="71"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">%</SPAN></TD></TR><TR><TD class="xl75" height="17"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">PC18</SPAN></TD><TD class="xl68" style="border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">1</SPAN></TD><TD class="xl75" style="border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">COX</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">25.00%</SPAN></TD></TR><TR><TD class="xl76" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS035</SPAN></TD><TD class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">1</SPAN></TD><TD class="xl76" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL03</SPAN></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR><TR><TD class="xl76" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS035</SPAN></TD><TD class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">2</SPAN></TD><TD class="xl76" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL04</SPAN></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR><TR><TD class="xl77" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS100</SPAN></TD><TD class="xl71" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">1</SPAN></TD><TD class="xl77" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL03</SPAN></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR><TR><TD class="xl77" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS100</SPAN></TD><TD class="xl71" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">2</SPAN></TD><TD class="xl77" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL04</SPAN></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Mon, 16 Apr 2018 07:43:35 GMT thomas_skariah 2018-04-16T07:43:35Z Rank and sort https://community.qlik.com/t5/QlikView/Rank-and-sort/m-p/39251#M6613 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">From below table can anyone suggest how to get rank column when the values are same and then arrange the rank by alphabetical order based on ID column.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">    </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" height="144" style="width: 383px; height: 130px;"><TBODY><TR><TD class="xl73" height="17" width="141"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">MeterNo</SPAN></TD><TD class="xl65" style="border-left: none;" width="98"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Rank</SPAN></TD><TD class="xl74" style="border-left: none;" width="98"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">ID</SPAN></TD><TD class="xl66" width="71"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">%</SPAN></TD></TR><TR><TD class="xl75" height="17"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">PC18</SPAN></TD><TD class="xl68" style="border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">1</SPAN></TD><TD class="xl75" style="border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">COX</SPAN></TD><TD align="right" class="xl69" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">25.00%</SPAN></TD></TR><TR><TD class="xl76" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS035</SPAN></TD><TD class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">1</SPAN></TD><TD class="xl76" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL03</SPAN></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR><TR><TD class="xl76" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS035</SPAN></TD><TD class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">2</SPAN></TD><TD class="xl76" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL04</SPAN></TD><TD align="right" class="xl70" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR><TR><TD class="xl77" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS100</SPAN></TD><TD class="xl71" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">1</SPAN></TD><TD class="xl77" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL03</SPAN></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR><TR><TD class="xl77" height="17" style="border-top: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">VRSS100</SPAN></TD><TD class="xl71" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">2</SPAN></TD><TD class="xl77" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">BL04</SPAN></TD><TD align="right" class="xl72" style="border-top: none; border-left: none;"><SPAN style="font-family: calibri, verdana, arial, sans-serif;">33.33%</SPAN></TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Mon, 16 Apr 2018 07:43:35 GMT https://community.qlik.com/t5/QlikView/Rank-and-sort/m-p/39251#M6613 thomas_skariah 2018-04-16T07:43:35Z Re: Rank and sort https://community.qlik.com/t5/QlikView/Rank-and-sort/m-p/39252#M6614 <HTML><HEAD></HEAD><BODY><P>Maybe with a logic like: maxstring(Rank & ID) in a sort-expression.</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 16 Apr 2018 07:49:47 GMT https://community.qlik.com/t5/QlikView/Rank-and-sort/m-p/39252#M6614 marcus_sommer 2018-04-16T07:49:47Z