topic Re: Adding Ranking to objects - how to achieve this in QlikView

Adding Ranking to objects - how to achieve this

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have to add Rank to charts and graphs ordering value from large to small. How to achieve this? Please reply.

Anonymous — Tue, 07 Nov 2017 13:53:11 GMT

Hello Trail, there are a lot of ways to do this, how is your data?

prat1507 — Tue, 07 Nov 2017 13:57:17 GMT

You can use Rank() function or in the Sort tab you can sort by expression.

Regards

Pratyush

Anonymous — Tue, 07 Nov 2017 14:02:44 GMT

Hi Pratyush, can you kindly tell me where to best use the Rank function sharing the syntax as well.

prat1507 — Tue, 07 Nov 2017 14:21:04 GMT

Sure, you can use rank function to sort your chart, as well as give ranks to the dimensions basis any expression.

For. ex.

If your data is something like this

Student,Marks

Auro, 100

Ben, 30

Charles, 40

Dan, 70

and use a simple straight table

where you can use dimensions as Student, and get the ranks based on their Marks

using expression rank(Sum(Marks))

This will return

Auro 1

Dan 2

Charles 3

Ben 4

I hope you understand.

Regards
Pratyush