https://community.qlik.com/t5/QlikView/FirstSortedValue-problem/m-p/1629184#M446337 <P>Hello,</P><P>Im reading an Excel File with date and data Values (Random Data)</P><P>The idea in qlikview is show the last day of month with information</P><P>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</P><P>I need to show the last day with data each month.</P><P>&nbsp;</P><P>Thanks!</P> Fri, 27 Sep 2019 16:45:50 GMT pgalvezt 2019-09-27T16:45:50Z https://community.qlik.com/t5/QlikView/FirstSortedValue-problem/m-p/1629184#M446337 <P>Hello,</P><P>Im reading an Excel File with date and data Values (Random Data)</P><P>The idea in qlikview is show the last day of month with information</P><P>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</P><P>I need to show the last day with data each month.</P><P>&nbsp;</P><P>Thanks!</P> Fri, 27 Sep 2019 16:45:50 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-problem/m-p/1629184#M446337 pgalvezt 2019-09-27T16:45:50Z https://community.qlik.com/t5/QlikView/FirstSortedValue-problem/m-p/1629199#M446340 <LI-CODE lang="markup">=FirstSortedValue(Moneda,-aggr(sum({&lt;Moneda={"&lt;&gt;Null()"}&gt;}Fecha),Moneda,Fecha))</LI-CODE> Fri, 27 Sep 2019 17:46:30 GMT https://community.qlik.com/t5/QlikView/FirstSortedValue-problem/m-p/1629199#M446340 Frank_Hartmann 2019-09-27T17:46:30Z