topic Error in num(sum( statement in QlikView

Error in num(sum( statement

MattReinders — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Could use some help here. I am not sure why how to get this statement to work. Right now it has errors and I'm not sure how to make it correct.

= num(sum([Fiscal Year] = {$(=vCurrentYear)}, [Line Item Amt USD]), '$#,##0')

Anil_Babu_Samineni — Fri, 26 Apr 2019 02:26:15 GMT

Perhaps this?

= num(sum({<[Fiscal Year] = {$(=vCurrentYear)}>} [Line Item Amt USD]), '$#,##0')

= num(sum({<[Fiscal Year] = {"$(=vCurrentYear)"}>} [Line Item Amt USD]), '$#,##0')

= num(sum({<[Fiscal Year] = {"$(vCurrentYear)"}>} [Line Item Amt USD]), '$#,##0')