topic Re: Get records with highest dates in QlikView https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234824#M853669 <HTML><HEAD></HEAD><BODY><P>sample data is in attached qwv, Thx</P></BODY></HTML> Tue, 21 Feb 2017 10:21:02 GMT 2017-02-21T10:21:02Z Get records with highest dates https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234822#M853667 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have situation where I must extract records with highest starting date if they are more than one SifDat values..</P><P>Was tried with FirstSortedValue, but I always get blank records..</P><P>Any idea and thanks in advance,</P><P></P><P>Igor</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234822#M853667 2020-11-25T16:16:04Z Re: Get records with highest dates https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234823#M853668 <HTML><HEAD></HEAD><BODY><P>could u pls share some sample data </P></BODY></HTML> Tue, 21 Feb 2017 10:13:58 GMT https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234823#M853668 2017-02-21T10:13:58Z Re: Get records with highest dates https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234824#M853669 <HTML><HEAD></HEAD><BODY><P>sample data is in attached qwv, Thx</P></BODY></HTML> Tue, 21 Feb 2017 10:21:02 GMT https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234824#M853669 2017-02-21T10:21:02Z Re: Get records with highest dates https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234825#M853670 <HTML><HEAD></HEAD><BODY><P>Try below expression in chart</P><P></P><P><STRONG>=FirstSortedValue(&nbsp; [Starting Date],- aggr( max([Starting Date]),SifDat,SifraCen))</STRONG></P></BODY></HTML> Tue, 21 Feb 2017 10:23:58 GMT https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234825#M853670 sasikanth 2017-02-21T10:23:58Z Re: Get records with highest dates https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234826#M853671 <HTML><HEAD></HEAD><BODY><P>Thx a lot ..<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 21 Feb 2017 10:32:54 GMT https://community.qlik.com/t5/QlikView/Get-records-with-highest-dates/m-p/1234826#M853671 2017-02-21T10:32:54Z