Discussion Board for collaboration related to QlikView App Development.
I need your help to unpivot a crosstab table source file and once it is unpivoted, I need to load it as a regular table.
My source file looks similar to the picture below:
What I need to do is to is transpose or transform the data so that it looks like the figure below:
I am also including a sample dataset so you can you it as the source for your solution.
Thanks in advance for all your assistance and support.
CrossTable(Date, Forecast, 2)
The from clause will specify the source file.
View solution in original post
Eduardo, thanks for your all your help. The simple solution solved our problem.