Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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
Highlighted
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

Try this:

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

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

Capture.PNG

Highlighted
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