Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think it should be possible, but would you be able to share a sample to test this out?
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
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)
here it is. Try to expand any country and you´ll see that the ranking for country becomes lost.
than you but didn´t worked
Here is the excel you asked me. The images are the same.
did you see my example please?
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
thank you so much