topic Help with if sum in QlikView

Help with if sum

pgalvezt — Fri, 25 Jul 2014 13:36:25 GMT

Hello,

I have this expression:

=if (Val='a',Sum(Aggr(if(inv='AR000111',sum(Amount)+ 53165,sum(Amount)),inv)) ,sum(Amount_B) ) (Works Fine)

I want to sum this

Sum(Aggr(if(inv='AR000112',sum(Amount)+ 55900,sum(Amount)),inv))

I have tried with "AND" and "OR" But is not working.

Thanks!

veidlburkhard — Fri, 25 Jul 2014 13:45:25 GMT

Hi Pablo,

this should do it:

=if (Val='a',Sum(Aggr(if(inv='AR000111',sum(Amount)+ 53165,

If(inv='AR000112',sum(Amount)+ 55900,sum(Amount))),inv)) ,sum(Amount_B)

Burkhard

martynlloyd — Fri, 25 Jul 2014 13:52:15 GMT

AND and OR are boolean operators within the condition test,

as BV explains, what you need is the IF - ELSE construct, in QlikView the Else is the comma after the do-this-if-true part of the statement.

pgalvezt — Fri, 25 Jul 2014 13:54:36 GMT

Thanks Burkhard