topic Showing MTD values in QlikView

Showing MTD values

deepakqlikview_123 — Fri, 19 Aug 2016 09:00:58 GMT

Hi All,

Currently I want to show the values for max year -2 in a manner that whenever i can select apr values should be jan+feb+mar for max year -2

=Sum({<Year={'$(=(max(Year)-2))'},Month_Num={'<=$(=max(Month_Num))'},[Mining New]={"Mining"}>}Total)

But my expression not working whenever i am selection month.

Can you please suggest what changes i need to do in expression.

vinieme12 — Fri, 19 Aug 2016 09:05:37 GMT

if you have Year as a dimension, then use below

=Sum({<Year={">=$(=(max(Year)-2))"},Month_Num={"<=$(=max(Month_Num))"},[Mining New]={"Mining"}>}Total)

Fri, 19 Aug 2016 10:05:45 GMT

Since you select april using the month field you have add it to the experssion :

=Sum({<Year={'$(=(max(Year)-2))'},Month_Num={'<=$(=max(Month_Num)-1)'},[Mining New]={"Mining"},Month>}Total)