topic rank descending in QlikView

rank descending

gr_eldred — Thu, 16 Nov 2017 17:40:01 GMT

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

Re: rank descending

Anonymous — Thu, 16 Nov 2017 17:50:42 GMT

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

Re: rank descending

sunny_talwar — Thu, 16 Nov 2017 17:54:10 GMT

May be this

Rank(-Expression)

Re: rank descending

gr_eldred — Thu, 16 Nov 2017 18:16:23 GMT

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

Re: rank descending

Anonymous — Thu, 16 Nov 2017 18:23:03 GMT

use just it in the expression box

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

disregard "CD_SALA"

Re: rank descending

Monicalingan — Thu, 16 Nov 2017 18:24:41 GMT

rank(-amount)

Re: rank descending

gr_eldred — Thu, 16 Nov 2017 18:35:51 GMT

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

Re: rank descending

gr_eldred — Thu, 16 Nov 2017 18:40:05 GMT

hi Monica,

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

Re: rank descending

sunny_talwar — Thu, 16 Nov 2017 18:41:06 GMT

Re: rank descending

gr_eldred — Thu, 16 Nov 2017 18:56:16 GMT

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.

Re: rank descending

sunny_talwar — Thu, 16 Nov 2017 19:01:05 GMT

What is the condition for when there is a draw?

Re: rank descending

gr_eldred — Thu, 16 Nov 2017 19:19:52 GMT

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

Re: rank descending

sunny_talwar — Thu, 16 Nov 2017 19:32:49 GMT

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))

Re: rank descending

gr_eldred — Thu, 16 Nov 2017 19:47:01 GMT

one question

What is this part?

/1E10)

Re: rank descending

sunny_talwar — Thu, 16 Nov 2017 20:07:58 GMT

Dividing the column by 10000000000

Re: rank descending

gr_eldred — Fri, 17 Nov 2017 02:53:46 GMT

Wow,

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

Thank you.

Re: rank descending

sunny_talwar — Fri, 17 Nov 2017 12:15:25 GMT

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