topic Re: Sum Results from 2 Expressions in Pivot Table in QlikView

Sum Results from 2 Expressions in Pivot Table

Fri, 20 Jul 2012 14:29:00 GMT

Here's an easy question (I hope) from a Qlikview newbie. In a Pivot chart i have 2 expressions:

= sum(if(IsNull(TCWIPRemoveDate),TimecardWIPAmt))

and

= sum(if(IsNull(CostCardIsNB),CostcardWIPAmt))

I just want to add a third expression to the pivot chart that is a SUM of the other 2 values. Can someone assist? I think i just have a syntax issue, should be easy.

Basically = sum(if(IsNull(TCWIPRemoveDate),TimecardWIPAmt)) + sum(if(IsNull(CostCardIsNB),CostcardWIPAmt))

Re: Sum Results from 2 Expressions in Pivot Table

MayilVahanan — Fri, 20 Jul 2012 14:50:08 GMT

HI,

Try like this,

=Column(1) + Column(2)

Hope it helps

Re: Sum Results from 2 Expressions in Pivot Table

Mon, 23 Jul 2012 15:56:24 GMT

Funny, I knew it would be easy, just not THAT easy! Thank you so much for the quick reply.

Richard