Ranking

[#1]

Is it possible to just display the ranking of a single record without displaying the whole of the data

For example if the data ia as below:

Product Code	Value
TTA	8
TTB	10
TTC	3
TTD	12

It is possible to rank the values to get:

Product Code	Value	Rank
TTA	8	3
TTB	10	2
TTC	3	4
TTD	12	1

But is it possible just to display the rank of just one Product Code (say just TTA) without showing all the other Product Codes

ie:

Product Code	Rank
TTA	3

[gainkarthi]

Just use experssion instead of field in list box and add exerpssion like if(max(rank),Productcode) . Dont add Rank column.

[#3]

Hi,

The correct answer in the following discussion might be helpful:

http://community.qlik.com/message/152044#152044

Besr regards,

http://quickdevtips.blogspot.com/

[#4]

Hi simon

add this Set analysis into your expression

Rank (  {<ProductCode={TTA}>} ....)