Discussion Board for collaboration on QlikView Scripting.
Can someone help me with the following excel structure?
I need to read this into qlikview.
If you double click on the total value of the pivot table in excel, you 'll get a sheet with the raw data. Import the data into qlikview.
This is the source data.
It has the structure from a pivot table but isn't one in excel.
you have to load a crosstable, load at first the Historic data, than the LU-Data.
Greetings from munich
This is not an option because we can't work with named ranges in excel and the data will extend every year.
youtr script would look like this:
DataTmp:LOAD Country, Product, 'Historic' As Field, [Q1/05], [Q2/05], [Q3/05]FROMCrosstable.xls(biff, embedded labels, header is 1 lines, table is Tabelle1$);
Concatenate (DataTmp)LOAD Country, Product, 'LU' As Field, [Q1/051] As [Q1/05], [Q2/051] As [Q2/05]FROMCrosstable.xls(biff, embedded labels, header is 1 lines, table is Tabelle1$);
Data:CrossTable(Quarter, Value, 3)LOAD Country, Product, Field, [Q1/05], [Q2/05], [Q3/05]Resident DataTmp;
Drop Table DataTmp;
Greetings from Munich
Ok but what if next year a new quarter is added?
Than I need to change the whole script again...
OK, Elke, if you have to work with such awfull sources ...
This isn't an awfull source. This is a normal source used by a business owner to fill in data.
How would you suggest the business owner fills in the data on a user friendly way?
Best way is like this