Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a data set similar to this:
I need a formula that would return the sum of the 'Value' for the maximum 'StdDay' for each 'ID'. The result for this example should be 5+50+40 = 95.
Go to Solution.
sum(aggr(firstsortedValue(Value, -StdDay), ID))
Hope this helps!
=sum(aggr(FirstSortedValue(TOTAL <ID> Value, -StdDay),ID) )
Both answer are ok
Attached the QV