Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Valued Contributor

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


Can anybody point me in the right direction?


1 Reply

Re: Build Year to date calendar

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

Community Browser