topic Re: Rank Total in QlikView https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446915#M489294 <HTML><HEAD></HEAD><BODY><P>Sorry, I should have been more clear. The column Rank in the table is calulcated based upon the Sales Amount in the first column and would have the following expression SUM([Sales Amount]). I need to calculate the maximum rank (6) and return it for each record. Hopefully that is more clear.</P></BODY></HTML> Mon, 19 Nov 2012 14:24:57 GMT 2012-11-19T14:24:57Z Rank Total https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446913#M489292 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am struggling with something seemingly simple! I need to return the maximum rank from a table. e.g. from the table below, I need to return 6 on every record.</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales Amount</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Rank</STRONG></SPAN></TH></TR><TR><TD>10</TD><TD>2</TD></TR><TR><TD>20</TD><TD>4</TD></TR><TR><TD>30</TD><TD>5</TD></TR><TR><TD>45</TD><TD>6</TD></TR><TR><TD>5</TD><TD>1</TD></TR><TR><TD>15</TD><TD>3</TD></TR></TBODY></TABLE><P></P><P>Any help greatly welcomed as my brain is not functioning properly today!</P><P></P><P>Regards</P><P></P><P>Haider</P></BODY></HTML> Mon, 19 Nov 2012 14:11:42 GMT https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446913#M489292 2012-11-19T14:11:42Z Re: Rank Total https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446914#M489293 <HTML><HEAD></HEAD><BODY><P>It's not clear to me if Rank is a field or an expression in a chart object (with what dimensions)?</P><P></P><P>Maybe it's just like</P><P></P><P>=max(total Rank)</P><P></P><P>?</P></BODY></HTML> Mon, 19 Nov 2012 14:20:19 GMT https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446914#M489293 swuehl 2012-11-19T14:20:19Z Re: Rank Total https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446915#M489294 <HTML><HEAD></HEAD><BODY><P>Sorry, I should have been more clear. The column Rank in the table is calulcated based upon the Sales Amount in the first column and would have the following expression SUM([Sales Amount]). I need to calculate the maximum rank (6) and return it for each record. Hopefully that is more clear.</P></BODY></HTML> Mon, 19 Nov 2012 14:24:57 GMT https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446915#M489294 2012-11-19T14:24:57Z Re: Rank Total https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446916#M489295 <HTML><HEAD></HEAD><BODY><P>Hi Haider, </P><P>I have a similar issue to swuehl so made an assumption.</P><P>See sample attached. </P><P>Kind Regards,</P><P>Footsie</P></BODY></HTML> Mon, 19 Nov 2012 14:26:20 GMT https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446916#M489295 2012-11-19T14:26:20Z Re: Rank Total https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446917#M489296 <HTML><HEAD></HEAD><BODY><P>Perfect - many thanks. I was so close <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P></BODY></HTML> Mon, 19 Nov 2012 14:29:05 GMT https://community.qlik.com/t5/QlikView/Rank-Total/m-p/446917#M489296 2012-11-19T14:29:05Z