Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

gr_eldred
Contributor 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
psilva001
Contributor

Re: rank descending

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

Re: rank descending

May be this

Rank(-Expression)

gr_eldred
Contributor II

Re: rank descending

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

psilva001
Contributor

Re: rank descending

use just it in the expression box



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


disregard "CD_SALA"



example0000.png

Monicalingan
New Contributor III

Re: rank descending

rank(-amount)

gr_eldred
Contributor II

Re: rank descending

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

Highlighted
gr_eldred
Contributor II

Re: rank descending

hi Monica,

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

rank2.png

Re: rank descending

More like this

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

gr_eldred
Contributor II

Re: rank descending

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