2 Replies Latest reply: Jul 23, 2012 11:56 AM by Richard Lowe RSS

    Sum Results from 2 Expressions in Pivot Table

      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))