Discussion board where members can get started with QlikView.
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.
Create a Year and Month field in resident load after your CrossTable Load and use Month as your first dimension and Year as your second dimension in the above chart.
View solution in original post
With these example script you can get YEAR and MONTH
How should I go about creating the Year and Month field please?
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,