topic Rank Function in QlikView https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152099#M29678 <HTML><HEAD></HEAD><BODY><P>I want to create following pivot table that shows rank of products.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 368pt; border-collapse: collapse;" width="490"><COLGROUP><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /><COL style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;" width="112" /><COL style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53" /><COL style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91" /><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="background-color: #1f497d; width: 88pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="117"><STRONG></STRONG></TD><TD class="xl64" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 124pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="165"><STRONG>Market 2</STRONG></TD><TD class="xl64" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 156pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="208"><STRONG>Market 2</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Prroduct</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P1</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">100</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">50</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P2</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">500</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #5a5a5a; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">TOTAL</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">300</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">550</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>But when I created this in qlikview pivot table I got the following results. Its showing the rank of products by market and is not what I</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 368pt; border-collapse: collapse;" width="490"><COLGROUP><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /><COL style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;" width="112" /><COL style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53" /><COL style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91" /><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: #1f497d; width: 88pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="117"><STRONG></STRONG></TD><TD class="xl66" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 124pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="165"><STRONG>Market 2</STRONG></TD><TD class="xl66" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 156pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="208"><STRONG>Market 2</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Prroduct</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl68" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P1</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">100</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">50</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl68" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P2</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">500</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #5a5a5a; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">TOTAL</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">300</TD><TD class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">550</TD><TD class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>I am using this expression to calculate rank.</P><P>Rank(TOATAL sum(Sales))</P><P>Can any one help me how to calculate rank as shown in first table?</P></BODY></HTML> Fri, 06 Aug 2010 18:28:46 GMT 2010-08-06T18:28:46Z Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152099#M29678 <HTML><HEAD></HEAD><BODY><P>I want to create following pivot table that shows rank of products.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 368pt; border-collapse: collapse;" width="490"><COLGROUP><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /><COL style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;" width="112" /><COL style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53" /><COL style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91" /><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="background-color: #1f497d; width: 88pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="117"><STRONG></STRONG></TD><TD class="xl64" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 124pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="165"><STRONG>Market 2</STRONG></TD><TD class="xl64" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 156pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="208"><STRONG>Market 2</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl63" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Prroduct</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl63" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P1</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">100</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">3</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">50</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">4</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl66" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P2</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">500</TD><TD align="right" class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #5a5a5a; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">TOTAL</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">300</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">550</TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>But when I created this in qlikview pivot table I got the following results. Its showing the rank of products by market and is not what I</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 368pt; border-collapse: collapse;" width="490"><COLGROUP><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /><COL style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;" width="112" /><COL style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;" width="53" /><COL style="width: 68pt; mso-width-source: userset; mso-width-alt: 3328;" width="91" /><COL style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;" width="117" /></COLGROUP><TBODY><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="background-color: #1f497d; width: 88pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="117"><STRONG></STRONG></TD><TD class="xl66" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 124pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="165"><STRONG>Market 2</STRONG></TD><TD class="xl66" colspan="2" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; width: 156pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="208"><STRONG>Market 2</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl65" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Prroduct</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Sales</STRONG></TD><TD class="xl65" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #1f497d; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG>Rank</STRONG></TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl68" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P1</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">100</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">50</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">2</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl68" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #1f497d; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">P2</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">200</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">500</TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;">1</TD></TR><TR height="17" style="height: 12.75pt;"><TD class="xl69" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: #5a5a5a; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;">TOTAL</TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">300</TD><TD class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;">550</TD><TD class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #5a5a5a; border-top: windowtext; border-right: windowtext 0.5pt solid;"></TD></TR></TBODY></TABLE><BR /><BR /> <P></P><P>I am using this expression to calculate rank.</P><P>Rank(TOATAL sum(Sales))</P><P>Can any one help me how to calculate rank as shown in first table?</P></BODY></HTML> Fri, 06 Aug 2010 18:28:46 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152099#M29678 2010-08-06T18:28:46Z Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152100#M29679 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You need to use a function AGGR into your expression.</P><P></P></BODY></HTML> Fri, 06 Aug 2010 21:02:34 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152100#M29679 2010-08-06T21:02:34Z Rank Function https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152101#M29680 <HTML><HEAD></HEAD><BODY><P>Great!</P><P>Exactly what I needed.</P><P>Thanks again.</P><P>Zubair.</P></BODY></HTML> Sat, 07 Aug 2010 07:25:40 GMT https://community.qlik.com/t5/QlikView/Rank-Function/m-p/152101#M29680 2010-08-07T07:25:40Z