topic Rank Function in straight table in QlikView https://community.qlik.com/t5/QlikView/Rank-Function-in-straight-table/m-p/965196#M330903 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a customer name selector on my report, the customer is single selected.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 231px;"><TBODY><TR><TD class="xl63" height="20" width="103"> </TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Sales</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Rank</TD></TR><TR><TD class="xl63" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Product 1</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">102</TD></TR><TR><TD class="xl63" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Product 2</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">122</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14</TD></TR><TR><TD class="xl63" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Product 3</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1341</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14</TD></TR></TBODY></TABLE><P></P><P>The above table should show me the rank of the selected customer (among all customers for that product) for the different products.</P><P></P><P></P><P>Thanks,</P><P>Gaurav</P></BODY></HTML> Mon, 23 Nov 2015 15:22:34 GMT 2015-11-23T15:22:34Z Rank Function in straight table https://community.qlik.com/t5/QlikView/Rank-Function-in-straight-table/m-p/965196#M330903 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a customer name selector on my report, the customer is single selected.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 231px;"><TBODY><TR><TD class="xl63" height="20" width="103"> </TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Sales</TD><TD class="xl63" style="border-left-color: currentColor; border-left-width: medium; border-left-style: none;" width="64">Rank</TD></TR><TR><TD class="xl63" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Product 1</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">10</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">102</TD></TR><TR><TD class="xl63" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Product 2</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">122</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14</TD></TR><TR><TD class="xl63" height="20" style="border-top-color: currentColor; border-top-width: medium; border-top-style: none;">Product 3</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">1341</TD><TD align="right" class="xl63" style="border-top-color: currentColor; border-left-color: currentColor; border-top-width: medium; border-left-width: medium; border-top-style: none; border-left-style: none;">14</TD></TR></TBODY></TABLE><P></P><P>The above table should show me the rank of the selected customer (among all customers for that product) for the different products.</P><P></P><P></P><P>Thanks,</P><P>Gaurav</P></BODY></HTML> Mon, 23 Nov 2015 15:22:34 GMT https://community.qlik.com/t5/QlikView/Rank-Function-in-straight-table/m-p/965196#M330903 2015-11-23T15:22:34Z