Discussion Board for collaboration on QlikView Scripting.
Hi , I got a requirement that i have shuffle column as row. below is the requirement
I will look forward to appreciate your answer
Go to Solution.
Yes Adam, I have already done with the requirement but forgot to close the thread. Thank you
Can you not simply deploy as a pivot table in the front end?
Please try this
CrossTable(salesinstack, value, 3)
(ooxml, embedded labels, table is Sheet1);
generic Load Item,
Stock,value Resident tab1;
or you can use crosstable
pivot table :dimentions are item,itemtype,salesinstack,store1,store2
under transformation wizard select crosstable ,set qualifier field is 3,Attribute field is salesinstack and Data field is Value.