Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Master Calendar Question

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!

2 Replies
Fabiano_Martino_Intelco
Partner - Creator II
Partner - Creator II

vikasmahajan

Hi,

Please refer this complete script 

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.