Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
haneeshmarella
Creator II
Creator II

Rank Function Problem

AssociateAvg. PicksRank
121
B151
C791

 

Hi guys,

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!

Labels (3)
1 Solution

Accepted Solutions
rubenmarin

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])"

View solution in original post

1 Reply
rubenmarin

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])"