topic Re: Rank given a specific user in QlikView

Rank given a specific user

Anonymous — Mon, 01 Feb 2016 16:18:21 GMT

I am trying to get a rank of a specific user without selecting them in a listbox. For example, if I have the table below

a 20

b 15

c 30

d 10

and I wanted to show the rank of b in a text box, I want to display b = 2. That box should always show the rank of b even if any selections are made.

Thanks!

sunny_talwar — Mon, 01 Feb 2016 16:52:25 GMT

Try this:

If(Sum(Sales) > 0, Rank(Sum({1}Sales)))

=Aggr(If(Sum(Value) > 0, Rank(Sum({1}Value))), Dim)

Anonymous — Mon, 01 Feb 2016 16:54:30 GMT

I figured out what I was trying to do.

Only({<Field={'b'}>} aggr(rank(sum({1}Sales)), Field)

Thanks for your help!

sunny_talwar — Mon, 01 Feb 2016 17:23:00 GMT

Awesome. I suggest closing this thread down by selecting correct and helpful answers

Best,

Sunny