Discussion Board for collaboration related to QlikView App Development.
I have a demo data and app where I have Actual and Budget data. I need the last expression total (sum of Rows) value in a textobject. Is it possible through expression label or any if other way out is there ?
This might work also, if you have one value per day for Actual and Budget
=Sum(Fabs(Actual - Budget))
If not, then go with stabben23's solution
Well this might just be some mocked up data and it might not work in real scenario. But ya def worth checking because it would be a good idea to avoid Aggr() if we can.
Based on Steffan solution I was trying to resolve but getting 0 where in dimension I am using TimeDim cyclic group and actual and budget this two expressions I am storing in a variable which I am referring.
I am using below expression,
I dont know why you are using GetCurrentField in a textbox?
try Without that,