topic Re: Rank function in QlikView

Rank function

Tue, 26 Mar 2013 07:44:20 GMT

Hi guys,

I just wanted to ask if I wanted to rank an expression but in this scenario a lower number should be ranked higher than a higher number.

So if the set consisted of {3, 6, 8,} then 3 should be ranked as the 1st, 6 should be ranked as 2nd and 8 should be ranked as 3rd. Is there a provision for this option in the rank function?

Regards

Re: Rank function

Gysbert_Wassenaar — Tue, 26 Mar 2013 07:49:34 GMT

Use rank( -1* Value) instead of rank(Value)

or rank(-Value) or -rank(Value)

Re: Rank function

CELAMBARASAN — Tue, 26 Mar 2013 07:51:23 GMT

Hi,

You can achieve this by adding - ve sign before it

Use Rank(-FieldName) or Rank(-Sum(FieldName))

Hope it helps

Celambarasan

Re: Rank function

Tue, 26 Mar 2013 07:53:25 GMT

Yeah of course. Stupid question