Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
juleshartley
Specialist
Specialist
‎2015-10-21 06:50 AM

Build Year to date calendar


hi All,

I'm sure I had this but I can't find it. I'm looking for a bit of script to build a calendar that has month-end in one column and 'report month YTD' in another column. eg:

Month End          YTD Month

31/1/2010          31/1/2010

31/01/2010          28/02/2010

28/02/2010          28/02/2010

etc...

Can anybody point me in the right direction?

Thanks,
J

1,542 Views
0 Likes
1 Reply
marcus_sommer
MVP
MVP
‎2015-10-21 07:33 AM

I don't understand excactly what do you try to do but here: How to use - Master-Calendar and Date-Values you will find various examples to build a master-calendar and also to implement various kinds of flagging like rolling periods, YTD/QTD/MTD, MonthEnd's and so on.

- Marcus

1,268 Views
0 Likes