Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor II
Partner - Contributor II

How to create Master calendar on the basis of Month name


This is my data i want to create master calendar MTD, YTD on the basis of the field

Qlik Sense Business  Qlik Sense Desktop  Qlik Sense Mobile 

1 Reply


You need to include at least year while generating calendar  using makedate function in qlik

for eg

MakeDate(transaction_year, transaction_month, transaction_day) as "Transaction Date",

transaction_day = 01   first day of every month 

after generating date  this you need to create master calendar using this date.


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.