Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
MayilVahanan

HI,

     Try like this,

     =Column(1) + Column(2)

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI,

     Try like this,

     =Column(1) + Column(2)

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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

Richard