Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bbmmouha
Contributor

Rank client in the same region

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

1 Solution

Accepted Solutions

Re: Rank client in the same region

This?

Capture.PNG

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

Capture.PNG

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

10 Replies

Re: Rank client in the same region

This?

Capture.PNG

bbmmouha
Contributor

Re: Rank client in the same region

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

This?

Capture.PNG

bbmmouha
Contributor

Re: Rank client in the same region

thanks i will test it

Re: Rank client in the same region

Sounds good

bbmmouha
Contributor

Re: Rank client in the same region

good morning

didn't work

bbmmouha
Contributor

Re: Rank client in the same region

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

Capture.PNG

bbmmouha
Contributor

Re: Rank client in the same region

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

This?

Capture.PNG

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

Capture.PNG

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

Community Browser