topic Re: Qlik Sense Master Calendar in Visualization and Usability

Qlik Sense Master Calendar

piyush_s11 — Wed, 22 Dec 2021 16:59:54 GMT

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.

Re: Qlik Sense Master Calendar

miskinmaz — Mon, 23 Sep 2019 12:04:39 GMT

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.

Re: Qlik Sense Master Calendar

piyush_s11 — Mon, 23 Sep 2019 12:15:19 GMT

Hi Miskinmaz,

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

Re: Qlik Sense Master Calendar

tresB — Fri, 27 Sep 2019 12:41:40 GMT

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