topic Num(Sum Error in QlikView

Num(Sum Error

Fri, 12 Jun 2015 20:38:08 GMT

I'm hoping someone can help with this expression. The first expression I have working with no issues:

='Actual - ' & num(sum([AE Expense Amount]), '$#,##0')

This one not so much. I would like to get the sum of the expense field for the current year inly without having to hard code it. Any help is greatly appreciated.

='Actual - ' & num(sum({<Year={$(=$(vCurrYear))},[AE Expense Amount]), '$#,##0')

Re: Num(Sum Error

ramoncova06 — Fri, 12 Jun 2015 20:42:41 GMT

you were missing the analysis closing bracket

='Actual - ' & num(sum({<Year={"$(=$(vCurrYear))"}>}[AE Expense Amount]), '$#,##0')

Re: Num(Sum Error

Fri, 12 Jun 2015 21:21:46 GMT

Thank you greatly!!