Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qlik Sense Master Calendar

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

clipboard_image_0.pngHow 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.

3 Replies
Highlighted
Creator III
Creator III

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.

Highlighted
Creator
Creator

Hi Miskinmaz,

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

Highlighted
MVP
MVP

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 <>;