Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
haneeshmarella
Contributor 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

Re: Rank Function Problem

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

1 Reply

Re: Rank Function Problem

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