FirstSortedValue problem

[pgalvezt]

Hello,

Im reading an Excel File with date and data Values (Random Data)

The idea in qlikview is show the last day of month with information

Jan and Apr show data because the last day has data. but Feb and Mar hasn't so I expect QlikView search the next Data on Feb 27th

I need to show the last day with data each month.

Thanks!

[Frank_Hartmann · Accepted solution]

=FirstSortedValue(Moneda,-aggr(sum({<Moneda={"<>Null()"}>}Fecha),Moneda,Fecha))