Discussion board where members can get started with QlikView.
What is the exact opposite of FirstSotedValue i.e some thing like LASTSortedValue?
Go to Solution.
The opposite is the firstsortedvalue too, only you put a - in front of the field/expression you want to sort on.
firstsortedvalue(Customer, Orderdate) gets the customer with the minumum orderdate
firstsortedvalue(Customer, -Orderdate) gets the customer with the maximum orderdate