Discussion Board for collaboration on QlikView Scripting.
I'm trying to create a table in the format :
Year, Item, Value/Qty and Month
At the moment it has a value for each month going horizontally instead a long skinny format.
It is currently in the format:
Required format :
Root:CrossTable(Month, Value, 2)LOAD Year, Item, SMQ01, SMQ02, SMQ03, SMQ04, SMQ05, SMQ06, SMQ07, SMQ08, SMQ09, SMQ10, SMQ11, SMQ12FROMcrosstable.xlsx(ooxml, embedded labels, table is Sheet1);
New:load*,Right(Month, 2) as MonthNewResident Root;drop Table Root;
CrossTable(month, value, 2)
(ooxml, embedded labels, table is Sheet1);
Right(month, 2) as month2
drop Table a;
hope this helps you.
please see the attached file.this file show the output like this