topic Re: create master calendar with month only. in QlikView

create master calendar with month only.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 10 Aug 2017 18:28:05 GMT

Check here:

vijayaganesh_s — Sun, 07 Oct 2018 17:20:43 GMT

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