Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.