topic Re: Difference between two columns in QlikView

Difference between two columns

Mon, 23 Jan 2017 20:44:00 GMT

Hi,

I facing an issue when I do simple subtraction like sum(A) - sum(B)

foe eg : sum A Sum B Total it is not correct

40 -35 75

Please find attached sample application for validation.

Regards,

Srinath. !

Re: Difference between two columns

sunny_talwar — Mon, 23 Jan 2017 20:47:26 GMT

Then do a straight sum

Sum(Sales) + Sum(Target)

You are subtracting a negative number which end up being added

Re: Difference between two columns

sunny_talwar — Mon, 23 Jan 2017 20:51:26 GMT

Or may be this as it seems that target is sometimes positive and sometimes negative

Sum(Sales) - Sum(fabs(Target))

Re: Difference between two columns

Mon, 23 Jan 2017 21:05:52 GMT

Thanks you are grate...

Re: Difference between two columns

Mon, 23 Jan 2017 21:16:00 GMT

Sunny i got one Doubt

45 -40 out put should be -ve values i think so

Re: Difference between two columns

sunny_talwar — Mon, 23 Jan 2017 21:52:39 GMT

45 - 40 should be negative??? Really? 45 is greater than 40 and if you subtract a smaller number from a larger number, you get a positive value. I am not sure what you are looking to get. May be you want to do Sum(Fabs(Target)) - Sum(Sales)? which will be 40 - 45... Is that what you want?