You want to get the Value corresponding to the highest Scenario_ID per Project_ID. So try:
See attached qvw for how the firstsortedvalue function works for your example.
comm66012.qvw 135.8 K
OK, thank you for your example.
I simplified my example to post it on QlikCommunity.
In my table, I've got multiple occurences of the same Project_Id and Scenario_Id and I would like to sum the values of these occurences.
In my example, if I Have
1000 1 10
1000 2 20
1000 3 30
1000 3 40
I would like to obtain :
1000 70 (= 30 +40)
Expression like FirstSortedValue(Sum(Value),-Scenario_Id) does not work
Do you think I can still use FirstSortedValue in ma case ?