topic Re: How to get sequence ranking in QlikView

How to get sequence ranking

Sun, 27 Jul 2014 16:26:43 GMT

Hi,

I have below data and want to achieve ranking, but it gives me different way.

PROD Sales Rank

A 12 1

B 10 2

C 8 3-4

D 8 3-4

I am expecting Ranks should be 1,2,3,4, how to achieve this.

Thanks,

Re: How to get sequence ranking

Sun, 27 Jul 2014 16:54:44 GMT

Hello,

I believe you're using this expression: rank(sum(Sales)).

Try this one instead to get the result you want (sequential ranking): num(rank(sum(Sales), 4))

I also suggest you check under QlikView help the below topic for examples and detailed explanation:

Examples of Chart Ranking Functions

Re: How to get sequence ranking

maxgro — Sun, 27 Jul 2014 16:59:21 GMT

for Rank column use expression rank(....., 4)

and format expression in Number tab as Integer

Re: How to get sequence ranking

Anonymous — Sun, 27 Jul 2014 17:04:30 GMT

jp above is correct above. The joker here may well have been that rank() returns a dual value, compare these two expressions where the num() & text() show the two different dual representations :

num(rank(sum(Value), 4))

text(rank(sum(Value), 4))

Re: How to get sequence ranking

Mon, 28 Jul 2014 07:14:48 GMT

Hi,

Use this expression for Rank

=Aggr(Num(Rank(Sum(Sales),4,1)),PROD)

It's working

Regards,

Vivek