Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
krithikarees
New Contributor III

Sum two columns and Substract it in multibox

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

2 Replies
vishsaggi
Esteemed Contributor III

Re: Sum two columns and Substract it in multibox

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

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