How to restrict a Date and year values in an expression

[Anonymous]

Hi All,

I want to calculate a KPI for  ...  Sum(Value).

The required o/p is

1)Sum of Value for entire Current year and upto previous month

=num(sum({<CalendarDate={'<=$(v_MaxMonth)'},AC_FiscalYear={'2017'}>}Value),'#,##0')

  2)Sum of Value for Current year previous month.

=sum({<FiscalYear={'2017'},CalendarDate  = {$(= Max([CalendarDate (#)]), -1)},CalendarDate=>}Value)

I used the above formulas are not working.

Cann any one help on this.

[Anonymous]

Thanks Sunny, it is working as expected.

[sunny_talwar]

If you are satisfied with the response, please close the thread by marking the correct response and any helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny