Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wangxusq
New Contributor III

Rank Issue

Hi everybody,

See the below picture:

12.png.

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.

Tags (1)
1 Solution

Accepted Solutions
ahaahaaha
Honored Contributor

Re: Rank Issue

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

4 Replies
ogster1974
Honored Contributor II

Re: Rank Issue

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

Regards

Andy

ahaahaaha
Honored Contributor

Re: Rank Issue

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

wangxusq
New Contributor III

Re: Rank Issue

Thanks very much

wangxusq
New Contributor III

Re: Rank Issue

Thanks, done.