create master calendar with month only.

[Anonymous]

Hi All,

I have a filed in my table is 'yearmth'.no need to use date. data as below,

id, name, yearmth, sales

1, a, 201601,100

2,b, 201612,120

3,c, 201706, 200

I want to create master calendar only with months.as shows in the screen shot. no need to show date.

Thanks in advance

[sunny_talwar]

Check here:

create calander months and years only | Qlik Community

[vijayaganesh_s]

Hi Somasundaram,

Try with the below code

LOAD * ,

DATE(YearMonthNum,'MMM YYYY')AS MMMYYYY;

LOAD * ,

Num(Date#(yearmth, 'YYYYMM')) AS YearMonthNum;

LOAD * INLINE [

id, name, yearmth, sales

1, a, 201601,100

2,b, 201612,120

3,c, 201706, 200];

Thanks,

VIjayaganeshS