Discussion Board for collaboration related to QlikView App Development.
I have two fields in data Id and sales. I am trying to take sum of sales for maximum value of ID but it is giving me sum only for 1 maximum id value which is at the last. the expression I am using is as below:
May be you need this
FirstSortedValue(Aggr(Sum(Sales), id), -id)
Also try this May be?
= Max(Aggr(Sum(Sales), Id))
Please check the screenshots.
Let me know.