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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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}