Discussion Board for collaboration on QlikView Scripting.
i need to load an excel file that is formatted this way into qlikview:
Is the first time i try to import this kind of data. I need them to be load in a linear way like:
Any idea's on how to achive this result?
Thanks and best regards,
Go to Solution.
Use the Crosstable prefix, and make sure to list the fields in the right order: First the non-months and then the months:
Crosstable (Month, Amount, 3)
Load Customer, AmountType, Adjustment, jan, feb, ... From ...
See also http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable
Thank You Henric the "right order" made my day