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: 
gr_eldred
Creator II
Creator II

rank descending

Hi,

With this function I have managed to get the ranking but I need to start the ranking from the value with the least amount

example:

amount    Rank

5                 2

7                 3

2                 1

8                 4

9                 5

Can anybody help me?

regards

16 Replies
Anonymous
Not applicable

Chart Properties>>Sort>> (Choose the Dimension) Sort by EXPRESSION>>(Set your expression)

sunny_talwar

May be this

Rank(-Expression)

gr_eldred
Creator II
Creator II
Author

my expression is as follows:

num(Rank([Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App],1))

does not allow to enter expression in sort

Anonymous
Not applicable

use just it in the expression box



[Rank Mac] + [Rank iPad] + [Rank iPhone] + [Rank Watch] + [Rank Acc App]


disregard "CD_SALA"



example0000.png

Monicalingan
Contributor III
Contributor III

rank(-amount)

gr_eldred
Creator II
Creator II
Author

hi

I already put the expression but it underlines me in red it seems that it is not allowed to use that way.

rank1.png

gr_eldred
Creator II
Creator II
Author

hi Monica,

num(Rank(-[Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App],1))

rank2.png

sunny_talwar

More like this

Num(Rank(-([Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App]),1))

gr_eldred
Creator II
Creator II
Author

Oh very well, if these parentheses were missing. Thank you so much. Thanks also to Monica

One more question in my data I have some repeated values for example

In the Global field I have two records with 81. Is there any way to use an additional condition so that I am not tied?

  the Column that I would use in case of having a serious draw rank iphone is marked in red.

rank3.png