Discussion Board for collaboration on QlikView Scripting.
How do I sum the resultant of this expression to display in a textbox?
Go to Solution.
It seems that if it is done in the inner aggregation, it works
May be this?
=Sum( Total FirstSortedValue(Aggr(Sum(FIELDNAME1),FIELDNAME2), -FIELDNAME2))
Will that work without the Aggr() Tresesco?
Shouldn't it be this
=Sum(Aggr(FirstSortedValue(Aggr(Sum(FIELDNAME1),FIELDNAME2), -FIELDNAME2), FIELDNAME2))
It should, because TOTAL is there.
I did not know that by using TOTAL you can avoid using an Aggr. I will try to test this out. Thanks
Tried something quite similar "Nested aggregation"
That expression return "0"
For some reason, it did not work for me
Would you be able to share an image of the chart where you are using this?