Discussion Board for collaboration on QlikView Scripting.
I need to load data from an excel and the data is in cross table.
Please find the details in the attached excel sheet.
There are two tabs in excel sheet.
I have given sample data in source tab.
In QlikView need to create List boxes based on heading mentioned in source tab.
Details have shown in Requirement tab.
Please help on this example.
(ooxml, embedded labels, table is Source, filters(
rename field F1 to Year;
rename field user to Month;
See attached qvw
It worked well with transposing data.
However if we have two fields in first two columns. Please find an example in attached file.
And please help on this example too..