Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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
sunny_talwar

What is the condition for when there is a draw?

gr_eldred
Creator II
Creator II
Author

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

rank4.png

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
Creator II
Creator II
Author

one question

What is this part?

/1E10)


sunny_talwar

Dividing the column by 10000000000

gr_eldred
Creator II
Creator II
Author

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