Help with if sum

[pgalvezt]

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 · Accepted solution]

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]

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]

Thanks Burkhard