Discussion board where members can get started with QlikView.
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.
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...
Your table expressions are not using fabs function, whereas your multibox expression is... do you know why you use different expressions?