topic Re: Is there a 'Lastsortedvalue' type function? in QlikView

Is there a 'Lastsortedvalue' type function?

Mon, 10 Dec 2012 14:25:04 GMT

I have 3 fields

Client

Month

Revenue

I'm trying to pull into a straight table a chart that will list the CLIENTS and show REVENUE for the latest month where the client had revenues.

Some clients don't have revenues in the latest month and instead of showing a blank, I'd like to show the monthly revenue for the latest month where it existed.

firstsortedvalue does the trick for the earliest month, but is there a function for the latest month?

Thanks in advance!

Re: Is there a 'Lastsortedvalue' type function?

swuehl — Mon, 10 Dec 2012 14:26:37 GMT

Use a negated sort weight, like -1 * MONTH as second argument to FirstSortedValue or just -MONTH:

=FirstSortedValue ( VALUE, -MONTH)

Re: Is there a 'Lastsortedvalue' type function?

Mon, 10 Dec 2012 14:28:00 GMT

I just saw that and it worked great. Thank you!

Re: Is there a 'Lastsortedvalue' type function?

alexC — Sun, 08 Jun 2025 13:34:39 GMT

Hi,

it doesnt work for me.
it work for "first" but not for "last" using "-"

FirstSortedValue(
{<update_date = {"<01/10/2024"}>}
subscription_status & ' (' & update_datetime & ')',
update_datetime_num
)

what do i do wrong?

Re: Is there a 'Lastsortedvalue' type function?

BrunPierre — Tue, 10 Jun 2025 08:22:40 GMT

@alexCyou should reverse the sort order using a negative sort weight and make sure it's a proper numeric timestamp.

-update_datetime_num