Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wangxusq
Contributor III
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.

1 Solution

Accepted Solutions
ahaahaaha
Partner - Master
Partner - Master

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

View solution in original post

4 Replies
ogster1974
Partner - Master II
Partner - Master II

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

Regards

Andy

ahaahaaha
Partner - Master
Partner - Master

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

wangxusq
Contributor III
Contributor III
Author

Thanks very much

wangxusq
Contributor III
Contributor III
Author

Thanks, done.