Solved: Opposite of FirstSortedValue - Qlik Community

Report Inappropriate Content · ‎2012-12-20

Hi,

What is the exact opposite of FirstSotedValue i.e some thing like LASTSortedValue?

Thx

C

Gysbert_Wassenaar · ‎2012-12-20

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

talk is cheap, supply exceeds demand

Gysbert_Wassenaar · ‎2012-12-20

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

talk is cheap, supply exceeds demand

er_mohit · ‎2012-12-20

use vlastsortedvalue