Master Calendar Question

[TomBond77]

Hi experts

I have a master calendar, check attached txt file.

In my App I would like to show also the weeks without  value on a measure. The master calendar is restricting the quantity of dates to the start date (earliest) and the end date (Latest) of the dataset.

min([Start]) as minDate,
max([End]) as maxDate

I now need for minDate: the first day of the month which belongs to "Start" and the last day of the month which belongs to "End" for maxDate. 

Thanks for your help!

[Fabiano_Martino_Intelco]

Hi @TomBond77 ,

you can use the monthstart and monthend functions.

The online help has some interesting examples:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...

Regards

Fabiano

[vikasmahajan]

Hi,

Please refer this complete script 

https://community.qlik.com/t5/Member-Articles/SIMPLE-MASTER-CALENDER/ta-p/1484974

Vikas