Master Calender for a field with data in fromat 'MMM-YY'

[diptojyotidutta]

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.

[Stoyan_Terziev]

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.