Discussion board where members can get started with QlikView.
Can anyone help me to find a solution how to transform a file with cross table ?
In the attached file i have the store, the item and the fields of qty from 1 to 31 that is the qty per day of the current month.
How can i change is to store, item, (date that is all the fields of the qty), qty
021, 1000006, 1 , 50
021, 1000006, 2 , 100
021, 1000006, 3, 70
and so on
Thank you in advance
Go to Solution.
CrossTable (ProductTemp, Quantity,2)
(biff, embedded labels, table is CROS_TABLE$);
PurgeChar(ProductTemp,'QST') as Product,
drop table QuantTrackingTemp;
View solution in original post
How are you getting 50, 100, 70 as qty? I see 4, 4, 4 for those three days in the Excel file
I gave an example only
So, the output based on your sample data would look like this?
021, 1000006, 1 , 4
021, 1000006, 2 , 4
021, 1000006, 3, 4
... and so on...