Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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))