Excel SUMIF equivalent.

[#1]

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

[its_anandrjs]

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

[swuehl]

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

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

Hope this helps,

Stefan

[#4]

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.

http://community.qlik.com/thread/38038

Dave

[#5]

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.

[swuehl]

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

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