Master Calender for a field with data in fromat 'M... - Qlik Community

diptojyotidutta · ‎2019-11-28

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 · ‎2019-11-28

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:

I hope that helps!

Kind regards,

S.T.

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