Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

juleshartley
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

etc...

Can anybody point me in the right direction?

Thanks,
J

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