topic Rank Functions in QlikView https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430869#M487817 <HTML><HEAD></HEAD><BODY><P>I am attempting to use Rank in a straight table and it is not working correctly.</P><P></P><P>This is an example of my two data tables</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="width: 205px; border: 1px solid #000000; height: 161px;" width="203"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Money</STRONG><BR /></TH></TR><TR><TD>Company A</TD><TD>10</TD></TR><TR><TD>Company B</TD><TD>20</TD></TR><TR><TD>Company C</TD><TD>45</TD></TR><TR><TD>Company D</TD><TD>15</TD></TR><TR><TD>Company E</TD><TD>25</TD></TR><TR><TD>Company F</TD><TD><P>30</P></TD></TR></TBODY></TABLE><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="width: 206px; border: 1px solid #000000; height: 144px;" width="204"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Group Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company Name</STRONG></SPAN></TH></TR><TR><TD>Group 1</TD><TD>Company A</TD></TR><TR><TD>Group 1</TD><TD>Company B</TD></TR><TR><TD>Group 2</TD><TD>Company C</TD></TR><TR><TD>Group 3</TD><TD>Company D</TD></TR><TR><TD>Group 3</TD><TD>Company E</TD></TR><TR><TD>Group 3</TD><TD>Company F</TD></TR></TBODY></TABLE><P></P><P>So I then set up a straight table that looks like this </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="91" style="width: 312px; border: 1px solid #000000; height: 85px;" width="310"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Group Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Money</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Rank</STRONG></SPAN></TH></TR><TR><TD>Group 1</TD><TD>30</TD><TD>-</TD></TR><TR><TD>Group 2</TD><TD>45</TD><TD>1</TD></TR><TR><TD>Group 3</TD><TD>70</TD><TD>-</TD></TR></TBODY></TABLE><P>My Rank formula is rank(Money), it is only ranking the one group that only has one company under it. Is there a way to fix this?</P></BODY></HTML> Tue, 12 Feb 2013 21:27:39 GMT 2013-02-12T21:27:39Z Rank Functions https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430869#M487817 <HTML><HEAD></HEAD><BODY><P>I am attempting to use Rank in a straight table and it is not working correctly.</P><P></P><P>This is an example of my two data tables</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="width: 205px; border: 1px solid #000000; height: 161px;" width="203"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">Money</STRONG><BR /></TH></TR><TR><TD>Company A</TD><TD>10</TD></TR><TR><TD>Company B</TD><TD>20</TD></TR><TR><TD>Company C</TD><TD>45</TD></TR><TR><TD>Company D</TD><TD>15</TD></TR><TR><TD>Company E</TD><TD>25</TD></TR><TR><TD>Company F</TD><TD><P>30</P></TD></TR></TBODY></TABLE><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="width: 206px; border: 1px solid #000000; height: 144px;" width="204"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Group Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Company Name</STRONG></SPAN></TH></TR><TR><TD>Group 1</TD><TD>Company A</TD></TR><TR><TD>Group 1</TD><TD>Company B</TD></TR><TR><TD>Group 2</TD><TD>Company C</TD></TR><TR><TD>Group 3</TD><TD>Company D</TD></TR><TR><TD>Group 3</TD><TD>Company E</TD></TR><TR><TD>Group 3</TD><TD>Company F</TD></TR></TBODY></TABLE><P></P><P>So I then set up a straight table that looks like this </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="91" style="width: 312px; border: 1px solid #000000; height: 85px;" width="310"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Group Name</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Money</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Rank</STRONG></SPAN></TH></TR><TR><TD>Group 1</TD><TD>30</TD><TD>-</TD></TR><TR><TD>Group 2</TD><TD>45</TD><TD>1</TD></TR><TR><TD>Group 3</TD><TD>70</TD><TD>-</TD></TR></TBODY></TABLE><P>My Rank formula is rank(Money), it is only ranking the one group that only has one company under it. Is there a way to fix this?</P></BODY></HTML> Tue, 12 Feb 2013 21:27:39 GMT https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430869#M487817 2013-02-12T21:27:39Z Re: Rank Functions https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430870#M487818 <HTML><HEAD></HEAD><BODY><P>try Rank(sum(money))</P></BODY></HTML> Tue, 12 Feb 2013 21:30:07 GMT https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430870#M487818 2013-02-12T21:30:07Z Re: Rank Functions https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430871#M487819 <HTML><HEAD></HEAD><BODY><P>Try this </P><P></P><P>=rank(aggr(sum(money),Groupname))</P></BODY></HTML> Tue, 12 Feb 2013 22:08:11 GMT https://community.qlik.com/t5/QlikView/Rank-Functions/m-p/430871#M487819 Anonymous 2013-02-12T22:08:11Z