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: 
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!