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: 
Not applicable

Rank Issues in Double Conditions

Hi Guys,

     The same ranks in the first column, I need to rank according to the reference_rank.aaa.jpg

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Are you sure you need rank for the second condition? Isn't it Enough sort?

Not applicable
Author

The first column has the same rank, like 4, 7,12. I need to distiguish the rank by the third field, like Rank_1

RankTotoal_PtsReference_RankRank_1
11921
21832
31713
41444
41486
41475
71357
71368
91299
10111010
1181211
1261112
1261313
1261414
alexandros17
Partner - Champion III
Partner - Champion III

what about concatenate the two fields into one and then ranking this new one?

Not applicable
Author

only the duplicated rank need to rank again..

Not applicable
Author

rank(total (

-rank(Totoal_Pts,1,1)*NoOfRows()+rank(Reference_Rank,1,1)

))

It's can also adapt to any number of conditions.