topic Re: MTD in QlikView

MTD

Tue, 25 Sep 2012 17:59:04 GMT

This is my equation for YTD

=Floor(Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(=addmonths(max(Date),-12))"}>} arqtyshp)).

Anybody colud tell me how to make it as MTD.

Thanks in Advance

MayilVahanan — Tue, 25 Sep 2012 22:51:51 GMT

Use MonthStart and MonthEnd Function

=Sum({<Date = {'>=$(=MonthStart(Max(Date))) <= $(=MonthEnd(Max(Date)))'}>}Sales)

Hope that helps

rajni_batra — Wed, 26 Sep 2012 06:47:16 GMT

=Floor(Sum({<Year={"$(=Year(Max(Date))-1)"}, Date= {"<=$(months(max(Date)))"}>} arqtyshp)).