Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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
Partner

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

View solution in original post

4 Replies
ogster1974
Master II
Master II

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

Regards

Andy

ahaahaaha
Partner
Partner

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.