Discussion board where members can get started with QlikView.
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?
I used rank([Avg. Picks]) and it gives me all 1's.I used the same way in another dashboard, and it works perfectly fine. No idea why this isn't though.
Thanks in advance!
Go to Solution.
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.If you need Avg. Picks as a dimension you can try with "Rank(TOTAL [Avg. Picks])"