Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
MattReinders
Contributor II
Contributor II

Error in num(sum( statement

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')

1 Reply
Anil_Babu_Samineni

Perhaps this?

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

Or

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

Or

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

 
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)