Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ZuhaibRana
Partner - Contributor III
Partner - Contributor III

How to create Master calendar on the basis of Month name

ZuhaibRana_0-1684839453992.png

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
vikasmahajan

Hi,

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.

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.