topic Re: Is there a LastValueSorted in QlikView

Is there a LastValueSorted

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Like FirstSortedValue, is there a LastValueSorted as I need the lowest value rather than the first, or is there another way?

Thanks

sunny_talwar — Tue, 25 Oct 2016 11:14:31 GMT

You can change the sort order

FirstSortedValue(Dim, -Date) -> 1st from the top

FirstSortedValue(Dim, Date) -> 1st from the bottom

sushil353 — Tue, 25 Oct 2016 11:15:31 GMT

hi,

You can use + or - sign to reverse the sorting order like:

firstsortedvalue(Customer,-orderDate)

HTH

shraddha_g — Tue, 25 Oct 2016 11:24:14 GMT

firstsortedvalue(Dimension, -Measure)

It will give you last value

Anonymous — Tue, 25 Oct 2016 11:26:42 GMT

Thanks guys, I've got the answer now lol.