Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
vikraant
Creator
Creator

How to make a Master Calendar when only Month Year is provided ?

Hi Everyone,

I want to make a calendar using just the month year data. The doubt that I have is should I create a field using MakeDate and assign all the intermediate dates or Calendar should be made directly using MonthYear.

Thank You!

1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

format that field as below and then use it for calculation of calender

date(date#(Month-year,'MMM-YYYY'))

View solution in original post

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

vikraant
Creator
Creator
Author

Hi Shraddha,

Actually the issue is I am having month-year(eg. Jan-2016) and that is the only date field available as of now since data is updated on monthly basis. I wanted to know would it be recommended to make a calendar for such a case?If yes then how?

Thank You

shraddha_g
Partner - Master III
Partner - Master III

format that field as below and then use it for calculation of calender

date(date#(Month-year,'MMM-YYYY'))

vikraant
Creator
Creator
Author

Thanks Shraddha!