Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how do I tie a ranking?

So... I´d like to tie a ranking using a second expression.... for example:

If I had a dimension like SalesPerson and a expression like Rank(sum(sales),0,1) I will have some Salesperson with the same ranking position ... so .. if it happens I´d like to use another expression to tie that using something like Rank(sum(sales) , Count(Distinct OrderNo))

Sales Personsum(sales)count(distinct OrderNo)Ranking Actual
Rank(sum(sales),0,1)
Desired Ranking
Rank(????)
Rob Carsson123,20012011
Joan Callins90,00029022
Frank Roll90,00013423
Helen Brolin50,00023944

Someone has a tip to do it ?

Thanks

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

rank( sum(Sales) + (count(distinct OrderNo)/1000), 0, 1)

View solution in original post

2 Replies
Not applicable
Author

rank( sum(Sales) + (count(distinct OrderNo)/1000), 0, 1)

Not applicable
Author

Great! ... Thank You