Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

MTD

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

1 Solution

Accepted Solutions
rajni_batra
Valued Contributor

Re: MTD

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

2 Replies

Re: MTD

Hi

Use MonthStart and MonthEnd Function

Like

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

Hope that helps

rajni_batra
Valued Contributor

Re: MTD

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

Community Browser