topic Re: Show Single Rank Value in QlikView

Show Single Rank Value

Thu, 17 Oct 2013 19:46:04 GMT

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!

rustyfishbones — Thu, 17 Oct 2013 20:02:04 GMT

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

when you slect Bob the text box will show 2

If you add this

you will get what you need

Clever_Anjos — Thu, 17 Oct 2013 20:04:49 GMT

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

Thu, 17 Oct 2013 20:22:57 GMT

Perfect, thank you very much!