Discussion board where members can get started with QlikView.
I have 3 fields
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!
Go to Solution.
Use a negated sort weight, like -1 * MONTH as second argument to FirstSortedValue or just -MONTH:
=FirstSortedValue ( VALUE, -MONTH)
I just saw that and it worked great. Thank you!