Discussion Board for collaboration on QlikView Scripting.
I am trying to transform an xls into a more reportable format in Qlikview, xls format is unfortunately is as below
I want to transform this data into below format , I tried cross table but was not able to work out how to do it easily. Please help !
I have achieved this by a short script like as below
LOAD DeptNo, DeptName, Date1, Exp1, Date2, Exp2, Date3, Exp3, Date4, Exp4, Date5, Exp5
Load DeptNo, DeptName, Dat1 as Date, Exp1 as Expense resident [Raw_data];
Do while a<6
Load DeptNo, DeptName, Date$(a) as Date, Exp$(a) AS Expense
drop table [Raw_Data];