Dynamic MTD Calculation

Thu, 15 Dec 2011 06:25:53 GMT

Hi ,

I trying to calculate dynamic MTD in stright table , I used below set anlysis to claculate this,

num(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"}>} [In profit center local currency_KSL]), '$#,##0;($#,##0)')

but this give out "0" if there are no values for the perticular document perticular for that month, I want only to on current month documetnt to be considered.Can any one help me on this ?

Dynamic MTD Calculation

perumal_41 — Thu, 15 Dec 2011 08:37:55 GMT

Hi,

please try this Expression .I thing Useful for U.

num(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=month(max(Date)))>$(=addmonths(month(max(Date)),-1))"}>} [In profit center local currency_KSL]), '$#,##0;($#,##0)')

Regards ,

Perumal.A

topic Dynamic MTD Calculation in QlikView

Dynamic MTD Calculation

Dynamic MTD Calculation