topic Re: Ranking in QlikView

Ranking

Fri, 25 May 2012 07:56:50 GMT

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:

It is possible to rank the values to get:

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 — Sun, 17 Jun 2012 06:21:11 GMT

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

Sun, 17 Jun 2012 08:54:50 GMT

Hi,

The correct answer in the following discussion might be helpful:

Besr regards,

Sun, 17 Jun 2012 10:17:32 GMT

Hi simon

add this Set analysis into your expression

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