topic Rank Function Problem in QlikView https://community.qlik.com/t5/QlikView/Rank-Function-Problem/m-p/1556740#M742991 <TABLE><TBODY><TR><TD>Associate</TD><TD>Avg. Picks</TD><TD>Rank</TD></TR><TR><TD>A&nbsp;</TD><TD>12</TD><TD>1</TD></TR><TR><TD>B</TD><TD>15</TD><TD>1</TD></TR><TR><TD>C</TD><TD>79</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Hi guys,</P><P>I try using the rank() function to rank associates based on avg. picks but it does not work, it gives me the same rank for everyone. What am I doing wrong?</P><P>I used rank([Avg. Picks]) and it gives me all 1's.<BR /><BR />I used the same way in another dashboard, and it works perfectly fine. No idea why this isn't though.</P><P>Thanks in advance!</P> Sat, 16 Nov 2024 04:10:01 GMT haneeshmarella 2024-11-16T04:10:01Z Rank Function Problem https://community.qlik.com/t5/QlikView/Rank-Function-Problem/m-p/1556740#M742991 <TABLE><TBODY><TR><TD>Associate</TD><TD>Avg. Picks</TD><TD>Rank</TD></TR><TR><TD>A&nbsp;</TD><TD>12</TD><TD>1</TD></TR><TR><TD>B</TD><TD>15</TD><TD>1</TD></TR><TR><TD>C</TD><TD>79</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Hi guys,</P><P>I try using the rank() function to rank associates based on avg. picks but it does not work, it gives me the same rank for everyone. What am I doing wrong?</P><P>I used rank([Avg. Picks]) and it gives me all 1's.<BR /><BR />I used the same way in another dashboard, and it works perfectly fine. No idea why this isn't though.</P><P>Thanks in advance!</P> Sat, 16 Nov 2024 04:10:01 GMT https://community.qlik.com/t5/QlikView/Rank-Function-Problem/m-p/1556740#M742991 haneeshmarella 2024-11-16T04:10:01Z Re: Rank Function Problem https://community.qlik.com/t5/QlikView/Rank-Function-Problem/m-p/1556754#M742992 <P>Hi, it looks like you are using Avg.Picks as dimension, leave Associate a the only dimension and set avg. Picks as an expression. Rank should work as you expect.<BR /><BR />If you need Avg. Picks as a dimension you can try with "Rank(TOTAL [Avg. Picks])"</P> Thu, 14 Mar 2019 18:01:31 GMT https://community.qlik.com/t5/QlikView/Rank-Function-Problem/m-p/1556754#M742992 rubenmarin 2019-03-14T18:01:31Z