Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Rank given a specific user

Hi

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!

1 Solution

Accepted Solutions
Contributor III
Contributor III

I figured out what I was trying to do.

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

Thanks for your help!

View solution in original post

3 Replies
Highlighted

Try this:

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

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

Capture.PNG

Contributor III
Contributor III

I figured out what I was trying to do.

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

Thanks for your help!

View solution in original post

Highlighted

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

Best,

Sunny