Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Opposite of FirstSortedValue

Hi,

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

Thx

C

Tags (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Opposite of FirstSortedValue

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
2 Replies
MVP & Luminary
MVP & Luminary

Re: Opposite of FirstSortedValue

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
Honored Contributor II

Re: Opposite of FirstSortedValue

use vlastsortedvalue