Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

View solution in original post

4 Replies
Highlighted
Master II
Master II

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

Regards

Andy

Highlighted
Master
Master

Hi,

Use

Num(Rank(sales, 4))

Ragrds,

Andrey

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks very much

Highlighted
Contributor III
Contributor III

Thanks, done.