How to Sort Others value in Bar chart when we are using Dimension Limits

[SatyaPaleti]

Hi  Friends,

I am having Yearly Sales. I want to show top 5 Years Sales. So In Dimension Limits I have selected for 5 Largest values. It is showing 5 largest values and It is also showing Others. So My requirement is Others should also Sort According to it. Please find below screenshot

Here it have show Others 1st and next Years 2004,2011,1994,2013

Is it possible in qlikview. if it is how?

Please find attached sample qvw and sample Data

Could you please help on this friends

Thank you,

Satya

[trdandamudi]

You will not find the attachment if you are in the "Inbox". So close your "Inbox" and open the article from the web page and you will see it..

It will look like the below screen shot when you open .from outside the "Inbox"...

[SatyaPaleti]

Thank you Thirumula It's really helpfull

[trdandamudi]

You are welcome... Glad I was able to help you. If you think you got the solution, please make sure you close the thread by selecting the correct answer. So that it will help others when needed.