Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
somspalanisamy
New Contributor III

create master calendar with month only.

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

mas.JPG


2 Replies

Re: create master calendar with month only.

Partner
Partner

Re: create master calendar with month only.

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