topic Re: Rank client in the same region in QlikView

Rank client in the same region

bbmmouha — Mon, 04 Jan 2016 12:50:40 GMT

hello

i have a problem whith Rank.

i have this exemple

region client sum(sels)

1 1 20

1 2 30

1 3 15

2 1 20

2 2 40

2 3 60

what i want is the rank of client in the region not in different region

for exemple rank client 1 in region 1 is 2

rank client 1 in region 2 is 3

thanks for help

Re: Rank client in the same region

sunny_talwar — Mon, 04 Jan 2016 13:31:51 GMT

This?

Re: Rank client in the same region

bbmmouha — Mon, 04 Jan 2016 16:48:51 GMT

thanks for reply

the region will be unique and he will select client like this

region rank

1 2

2 3

Re: Rank client in the same region

sunny_talwar — Mon, 04 Jan 2016 17:06:25 GMT

This?

Re: Rank client in the same region

bbmmouha — Mon, 04 Jan 2016 17:10:34 GMT

thanks i will test it

Re: Rank client in the same region

sunny_talwar — Mon, 04 Jan 2016 18:16:40 GMT

Sounds good

Re: Rank client in the same region

bbmmouha — Tue, 05 Jan 2016 08:58:18 GMT

good morning

didn't work

Re: Rank client in the same region

bbmmouha — Tue, 05 Jan 2016 09:05:02 GMT

he still Rank for the all region not in the same region

Re: Rank client in the same region

bbmmouha — Wed, 06 Jan 2016 11:03:34 GMT

what i wont is the rank of the selected client in the region

if i add the client as a dimention this will be ok but i have so much clients and the table will be not readable

any helps please

Re: Rank client in the same region

sunny_talwar — Wed, 06 Jan 2016 11:08:58 GMT

This?

The problem you will run into is that when you don't have any client selected it will show null

If that is acceptable then use this expression: =Aggr(If(Sum(Sales) > 0, Rank(Sum({<client>}Sales))), region, client)

Re: Rank client in the same region

bbmmouha — Thu, 07 Jan 2016 09:21:12 GMT

thanks a lot MR sunny T for your time