Discussion board where members can get started with QlikView.
I have some data in a source where every month is a seperate column instead of a field with the date.
THis makes it very difficult to make a selection for some months (and use a master calender).
In excell everything explained (tab 1 and 2).
Now it is impossible/ very difficult to make a selection for a specific range of months. That is why i prefer :
How can i solve this in some scripting / temp table?
Thanks in advance!
Go to Solution.
Which fields do you want to combine?
Unfortunately, you can't do a preceeding load on a crosstable, so you'll probably be looking for something like this. This will give you the output you want.
CrossTable(Month, Sales, 2)
(ooxml, embedded labels, table is Source);
subfield(Month, 'Sales ') as Month,
drop table NewTable_temp
Thanks for the solution!
I did't try it yet, but understand what you have done and that is absoluty the solution
Now you introduced the "crosstable" as solution,, i also found a tutorial: https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable
Thanks for your time and i will implement it tomorrow