Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Is there a 'Lastsortedvalue' type function?

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Is there a 'Lastsortedvalue' type function?

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

=FirstSortedValue ( VALUE, -MONTH)

2 Replies
MVP
MVP

Re: Is there a 'Lastsortedvalue' type function?

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

=FirstSortedValue ( VALUE, -MONTH)

Not applicable

Re: Is there a 'Lastsortedvalue' type function?

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

Community Browser