as per screen shot, I need the following to be displayed as Months and 2 lines representing the years.
The data for the YearMonth had been cross table
I could use excel to create a whole new column for Month and another for Year to do it but I think there should be a way in Qlikview.
Any help would be very much appreciated.
I have managed with the direction of resident Load.
Is alot more complicated than I expected and also needed to define the Month and Year.
thank you for pointing me in the right direction.
(biff, embedded labels);
Month(Date(Date#([When],'YYYYMM'))) as Month,
Year(Date(Date#([When],'YYYYMM'))) as Year
DROP Table first;
May be something like this:
Year(YearMonth) as Year,
Month(YearMonth) as Month;
Date(Date#(YearMonth, ‘YYYYMM’) , ‘YYYYMM’) as YearMonth,