topic Re: Rank - Mode 0,1,2,3,4 in QlikView

Rank - Mode 0,1,2,3,4

soloeeeoff — Thu, 29 Sep 2016 06:10:19 GMT

Hi all,

I tried Rank Function's Mode 0,1,2,3,4.

But it seems to be making No difference.

Please any one help me .

Thanks.

Anil_Babu_Samineni — Thu, 29 Sep 2016 15:30:19 GMT

Try

Hrank(expression, 0)

And same as 1,2,3...

sunny_talwar — Thu, 29 Sep 2016 15:35:54 GMT

Try adding a Num() function to see the difference or adding the second parameter

Rank(Sum(Data), 1, 1)

Rank(Sum(Data), 2, 1)

Rank(Sum(Data), 3, 1)

Rank(Sum(Data), 4, 1)

Rank(Sum(Data), 1, 2)

Rank(Sum(Data), 2, 2)

Rank(Sum(Data), 3, 2)

Rank(Sum(Data), 4, 2)

Num(Rank(Sum(Data), 1))

Num(Rank(Sum(Data), 2))

Num(Rank(Sum(Data), 3))

Num(Rank(Sum(Data), 4))