Discussion Board for collaboration on QlikView Scripting.
I have MS Excel data in the format:
To make this useable in QV - how do I Script a re-pivot so the data is loaded as:
Surely this is fundamentally what QV is used for and this should be straight forward?! - or am I approaching the issue incorrectly?
Go to Solution.
You have two columns you want in front, the months should end up in a field named Month and the amounts in a field named Amount. Use the crosstable function like this:
load * from ...etc
See the load script of the attached qvw
crosstable in script ..
Please refer this:
Hope it helps
Use "Crosstable" option.
It's THAT easy?! :-)
Thanks guys - it shows what formal training does for you (rather than learning as you go!) :-)
I'm afraid I have to award the Correct Answer to the first reply.
Write a script some thing like this in your script
Load * inline
Account, AccountName, January, February, March
1, My Account, 100, 200, 350