Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a field named Period in which the data is of the format 'MMM-YY' i.e, I have data like Jan-05, Feb-05, Jan-06, Feb-06 and so on.
So how shall i write the master calender out of the field.
Hi,
The easiest way would be to create a 'Date' field out of your period, which would look like:
Test:
LOAD
MonthStart(Date#(Period, 'MMM-YY')) as PeriodDate,
Period
;
Load * INLINE [
Period
Jan-19
Feb-19
Mar-19
Apr-19
May-19
];
And then follow the rest of the guidance in this thread:
https://community.qlik.com/t5/New-to-QlikView/How-to-Create-Master-Calendar/td-p/103109
I hope that helps!
Kind regards,
S.T.