5 Replies Latest reply: Apr 4, 2013 5:57 AM by Stefan Wühl

# Excel SUMIF equivalent.

Me again...

Tearing my hairout at the moment as my 2 short day's training obviously haven't fully equipped me.

What's the QlikView equivalent of Excel SUMIF?

Easy one, I hope!

Thanks.

QlikView for Windows Version 9.00.7646.9 SR6

• ###### Re: Excel SUMIF equivalent.

Hi,

You can use same as SUMIF of excel in qlikview it will be

SUM( IF(Condition),Value )

Examples:-

1. SUM( If(SomeColumn = 'A' ), Value )

2. SUM( If(SomeColumn >= 15 ), Value )

Rgds

Anand

• ###### Re: Excel SUMIF equivalent.

I am trying the following formula in a line graph, but its not working.

sum(if(Product='E'),Amount)

Product is a column and E is its value. I want to see the sum of amount if the Product is E.

• ###### Re: Excel SUMIF equivalent.

Please check your use of parentheses (), I think you should write it like

sum(if(Product='E',Amount))

• ###### Excel SUMIF equivalent.

It's probably an if() function embedded in a sum, something like

=sum(if(FIELD >0 , ANOTHERFIELD))

Hope this helps,

Stefan

• ###### Re: Excel SUMIF equivalent.

Thanks Anand and Stefan,

Unfortunately, I didn't explain my problem correctly... and it would have been better if I had added my query to my ongoing "New User needing an Epiphany" thread... which I will do now.