topic Re: Excel SUMIF equivalent. in QlikView

Excel SUMIF equivalent.

Fri, 28 Oct 2011 14:42:46 GMT

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.

its_anandrjs — Fri, 28 Oct 2011 14:46:47 GMT

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

Excel SUMIF equivalent.

swuehl — Fri, 28 Oct 2011 14:47:18 GMT

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.

Mon, 31 Oct 2011 08:58:32 GMT

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

Re: Excel SUMIF equivalent.

Thu, 04 Apr 2013 09:51:35 GMT

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.

swuehl — Thu, 04 Apr 2013 09:57:51 GMT

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

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