rank descending

[gr_eldred]

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

[sunny_talwar]

What is the condition for when there is a draw?

[gr_eldred]

In case the values in the global are the same check if in the column iphone 6wbl or rank iphone has more sales this will take the place

example: two records occupy the place 19 but in the column iphone 6wbl one has more percentage of sales therefore the one with the highest percentage will be place 19 and the other record will be place 20

[sunny_talwar]

Try one of these

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

or this

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

[gr_eldred]

one question

What is this part?

/1E10)

[sunny_talwar]

Dividing the column by 10000000000

[gr_eldred]

Wow,

I thank you for your help with what you just showed me is just what I need.

Thank you.

[sunny_talwar]

Great... I am glad I was able to help you out....

Please close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny