Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
newbie_sm
Contributor III
Contributor III

Sum number value with calculated expression

Is there a method to sum a number value with a caculated expression? e.g.

 

(Sum({<[Month Year]={'$(=Max(Date([Month Year], 'MMM-YYYY')))'},
[Customer_Code]=-{'A','B','C','D'}>} USD_Revenue)) and Sum(5000)

 

where the value returned would be 5000+ the calculated value from the data loaded?

 

Labels (3)
2 Replies
Mark_Little
Luminary
Luminary

(Sum({<[Month Year]={'$(=Max(Date([Month Year], 'MMM-YYYY')))'},
[Customer_Code]=-{'A','B','C','D'}>} USD_Revenue)) + 5000

newbie_sm
Contributor III
Contributor III
Author

THANKS! It worked

can I expand this with a if condition e.g.

(Sum({<[Month Year]={'$(=Max(Date([Month Year], 'MMM-YYYY')))'},
[Customer_Code]=-{'A','B','C','D'}>} USD_Revenue)) + (if([Month Year]={'Dec-2022'}, 5000, 3000))