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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SUM Where expression

I'm trying to insert a chart on my 'Amount' column where I only want to sum rows where 'Source' = 'REVENUE'. The 'Source' field contains 'REVENUE', 'COSTS', and 'BUDGET', but I only want the chart to include the Revenue rows. Can someone provide syntax for the expression?

Many thanks!

2 Replies
Not applicable
Author

Sum(IF(Source='Revenue,1,0)*amount) should be working.

Not applicable
Author

using set analysis:


Sum({<Source={'REVENUE'}>} Amount}