topic Sum two columns and Substract it in multibox in QlikView

Sum two columns and Substract it in multibox

krithikarees — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am unable to sum two columns and subtract from a table in multi box .

TABLE CALCULATION :

Time to failure iS : Rma issue date - ship date

Time to failure (today) is : today - ship date

Multi box calculation : =SUM(fabs(Interval(Today() - [Panel Ship Date]))) - SUM(fabs(Interval([RMA Issue Date] - [Panel Ship Date])))

but my totals in multi box are wrong.

Any help would be appreciated.

Thanks

Re: Sum two columns and Substract it in multibox

vishsaggi — Wed, 09 May 2018 16:14:01 GMT

What is the total you are expecting to see? Specific reason behind using this expr in Multibox? Can you share sample app to look into? Please share you expected output...

Re: Sum two columns and Substract it in multibox

sunny_talwar — Wed, 09 May 2018 16:36:34 GMT

Your table expressions are not using fabs function, whereas your multibox expression is... do you know why you use different expressions?