Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
nickedw0
Creator
Creator

Calendar with only a single entry per month

How can i generate a calendar which has only one entry per month. In other words I only want to have 12 entries per year.

1 Solution

Accepted Solutions
nickedw0
Creator
Creator
Author

Worked out answer:
Let vStartDate=Floor(MakeDate(2019));
Let vNumMonths = 12;

Cal:
Load TempDate as MonthDate;
Load RecNo()-1+AddMonths($(vStartDate),RecNo()) As TempDate
AutoGenerate(vNumMonths));

View solution in original post

1 Reply
nickedw0
Creator
Creator
Author

Worked out answer:
Let vStartDate=Floor(MakeDate(2019));
Let vNumMonths = 12;

Cal:
Load TempDate as MonthDate;
Load RecNo()-1+AddMonths($(vStartDate),RecNo()) As TempDate
AutoGenerate(vNumMonths));