Dimension value order changes when multiple data is loaded from excel

Mon, 03 Sep 2012 09:10:39 GMT

Hi everyone, this would be my first post in this community, pardon me if I have posted at the wrong place.

I am facing some issue after loading data from Excel data source, hope I can get some help with this. I’m trying to display the financial results of few companies in a pivot table. The results will change based on a list box selection. I can get it to work till this part but the issue here is the order of the dimension change when I load more than one company. It could either from few different sheets of all from one sheet. The order should be like below

But instead it comes out like below

Not all of it are off the order but just some, but the actual order is what needed. I have attached the excel document and qlikview document if its needed.

Thank you in advance for the help.

Vivek

topic Dimension value order changes when multiple data is loaded from excel in QlikView

Dimension value order changes when multiple data is loaded from excel