Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Single Rank Value

How can I display individual ranks of items?

An simple example, I have this table:

Name          Sales

Bob               100

Mary              300

Ted                 50

Using Rank in a chart is simple enough.  But how do I list a single rank for a person in a text object.   So I want to display:

Bob  2

Since Bob is second in the ranking.

(this must be very easy, I hope??)

Thank you!

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

='Bob : ' & only({<Name={"Bob"}>}aggr(rank(Sales),Name))

View solution in original post

3 Replies
rustyfishbones
Master II
Master II

Hi you can create a Text Box and type the following Expression

2013-10-17_2051.png

when you slect Bob the text box will show 2

If you add this

2013-10-17_2055.png

you will get what you need

Clever_Anjos
Employee
Employee

='Bob : ' & only({<Name={"Bob"}>}aggr(rank(Sales),Name))

Not applicable
Author

Perfect, thank you very much!