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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
deep2021
Creator III
Creator III

How optimize the below expression

Hi All,

 

Can you please suggest how to optimize the below expression,

 

Sum(if(Value=1 OR Value=2,[Amount]))

 

Thanks

Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Sum({<Value={1}>+<Value={2}>} Amount)

or

Sum({<Value={1,2}>} Amount)

View solution in original post

1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Sum({<Value={1}>+<Value={2}>} Amount)

or

Sum({<Value={1,2}>} Amount)