Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
soloeeeoff
New Contributor III

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

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 .

1.png

Thanks.

Tags (2)
2 Replies

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

Try

Hrank(expression, 0)

And same as 1,2,3...

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

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

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)


or

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

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

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

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