Rank Issue

[wangxusq]

Hi everybody,

See the below picture:

.

I do not want it to be  5-7 when Product are 4,3 and 6. I hope it is 5,6,7 by using the rank function. I hope I can get the unique number even if sum(sales) are equal. So what  is the parameter of  the  rank function? Or can not meet my requirement through qlikview set?

Thanks.

[ogster1974]

If you rank on sum(sales).product you should have your tie breaker right there.

Regards

Andy

[ahaahaaha · Accepted solution]

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

[wangxusq]

Thanks very much

[wangxusq]

Thanks, done.