Qlik Sense Master Calendar

[piyush_s11]

Hi,

I wanted to make a master calendar in which I wanted to evaluate Quarter, week etc. I have below 2 fields as date which only has month name & year. year consist of year + y letter preceded. please find below screenshot for 2 fields

How to create master calendar by using above fields. I want the script to create master calendar by using these 2 fields only. I don't have other date field. 

Thanks.

[miskinmaz]

You can refer the below post

https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286

You just need to consider the Time field.

[piyush_s11]

Hi Miskinmaz,

thanks for your reply. I have already tried that, unfortunately it is not working with my fields.

[tresesco]

Try like:

Load
     Makedate(Year,num(Month)) as Date,
     Month,
     Year;
Load
     Month(Date#(Time, 'MMM')) as Month,
     Mid(Years,2,4) as Year
From <>;