Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rcandeo
Contributor II

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

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?

9 Replies
MVP
MVP

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

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

miguelbraga
Valued Contributor III

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

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

galax_allu
Valued Contributor

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

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
Contributor II

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

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

rcandeo
Contributor II

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

than you but didn´t worked

rcandeo
Contributor II

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

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

ranking.jpg

rcandeo
Contributor II

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

did you see my example please?

MVP
MVP

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

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
Contributor II

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

thank you so much