topic SUM Where expression in QlikView

SUM Where expression

Mon, 19 Oct 2009 22:12:31 GMT

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!

SUM Where expression

Mon, 19 Oct 2009 22:13:37 GMT

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

SUM Where expression

Mon, 19 Oct 2009 22:19:11 GMT

using set analysis:


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