Discussion Board for collaboration related to QlikView App Development.
Could you please help me to bring the attached excel data into Qlikview as it is.
I have multiple sheets which needs be loaded into Qlikview but for now i am looking how to load the attached file into QV.
Should be simple and plain. Open your Qlik Desktop and CTRL + E (Edit Script) and click on Table Files and bring in the Excel file (One image). Second Image shows Sheet1$ (depicts what sheet one wants to open up in Qlik).
Hope it helps!!!!
This file is going to be very awkward to load. It combines multi level headers with multiple sub tables on a sheet. It is possible to construct a load script for this spreadsheet, but it will take a while and will probably not be that reliable (minor layout changes will break the load).
It it not possible to get the data reported in a more conventional form? A report like this is usually generated from an underlying source, perhaps you can look at that if you cannot get a simple report.