topic Re: rank() in QlikView

rank()

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

Hi Experts,

Can any one please help me on this .

In the below table for the the month year Apr 2018 for client002 The rank is 305

but when i filtered client0002 particularly then 305 changed to 1.

Please help me on this.

I have used this expression

aggr(rank(sum(score),0,1),clientid)

Thanks in advance

swuehl — Sat, 27 Jan 2018 13:40:19 GMT

Try maybe

aggr(rank(sum({1} score),0,1),clientid)

aggr(rank(sum({<clientid>}score),0,1),clientid)

swuehl — Sat, 27 Jan 2018 14:03:12 GMT

The first one ignores all selections, the second one only selections in your client field.

Both should work in priniciple. Have you tested the second?

And why are you using the Aggr() function here?

bhavvibudagam — Sat, 27 Jan 2018 16:09:24 GMT

HI Stefen,

I have prepared a sample app with sample files about the above rank() requirement.

I have 4 excel source files attached below.

I have to calculate the score of clients related to that month only in a Table box.

Suppose in the Jan month client0145 has the rank 1 with in feb month his rank is 2 based on that month related client score.Please help me on this.

Tried with aggregation function but not working. Please help me on this.

swuehl — Sat, 27 Jan 2018 16:39:56 GMT

=aggr(Rank(sum({1}Score)),Month, Client)