Is there a way to have double ranking in a dinamic table?

[rcandeo]

I have a dinamic table by country/customer and I would l iike to see ranking by country and when expanded, see a new rank by customer. Is this possible?

[sunny_talwar]

I think it should be possible, but would you be able to share a sample to test this out?

[miguelbraga]

Hey there,

After sharing with us a sample data, can you please explain in a excel sheet your desired output so we can develop a solution faster for you?

Best regards,

D.A. MB

[Anonymous]

not tested

try this ..

aggr(RANK(ONLY({1}sum(sales))),country).........country wise(Rank wont change with selection)

Aggr(Rank(Sum(Sales)), Country)........country wise (Rank changes with selection)

Aggr(Rank(Sum(Sales)), Customer)...........customer wise (Rank changes with selection)

[rcandeo]

here it is. Try to expand any country and you´ll see that the ranking for country becomes lost.

[rcandeo]

than you but didn´t worked

[rcandeo]

Here is the excel you asked me. The images are the same.

[rcandeo]

did you see my example please?

[sunny_talwar]

Hey Robson -

I did and I am not sure why QlikView is doing that. I think this seems like an intended behavior, but since you are looking for this, I will try to see if I can find a work around.

Best,

Sunny

[rcandeo]

thank you so much