Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Dimension value order changes when multiple data is loaded from excel

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.