YTD and MTD

_rohitgharat — Wed, 06 Jan 2016 17:32:18 GMT

Hi Guys,

I Have a date Key which consist of year and month i.e 201501,201502 and so on. I want to calculate YTD and MTD using this.Can suggest me how is it possible???

Thanks & Regards,

Rohit

Re: YTD and MTD

maxgro — Wed, 06 Jan 2016 17:42:42 GMT

Sorry but

Month-to-date (MTD) is a period starting at the beginning of the current month and ending at the current date

and you don't have the date in the date key field, you only have the month (all the date in the month)

Or I'm missing something?

Anyway, with a date field, d for example (DD/MM/YYYY is the format of the date field)

sum({<d={">=$(=date(monthstart(today()), 'DD/MM/YYYY'))<=$(=date(today(), 'DD/MM/YYYY'))"}>} v)

for YTD replace monthstart with yearstart

topic Re: YTD and MTD in QlikView

YTD and MTD

Re: YTD and MTD