topic getting last value within YTD(+60 day) range in QlikView https://community.qlik.com/t5/QlikView/getting-last-value-within-YTD-60-day-range/m-p/373928#M1175753 <HTML><HEAD></HEAD><BODY><P> Anyone?<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 30 May 2012 13:00:52 GMT 2012-05-30T13:00:52Z getting last value within YTD(+60 day) range https://community.qlik.com/t5/QlikView/getting-last-value-within-YTD-60-day-range/m-p/373927#M1175752 <HTML><HEAD></HEAD><BODY><P>Hi Good morning, I am using the expression:- FirstSortedValue(Meter_Reading,-Meter_Reading_Date) to get the most recent value extract from a QVD I use.</P><P></P><P>I am now looking to get the furthest single record that falls between 425 and 365 days from most recent value date.</P><P></P><P>Help much appreciated if you can.</P><P></P><P>Paul.</P></BODY></HTML> Wed, 30 May 2012 08:18:30 GMT https://community.qlik.com/t5/QlikView/getting-last-value-within-YTD-60-day-range/m-p/373927#M1175752 2012-05-30T08:18:30Z getting last value within YTD(+60 day) range https://community.qlik.com/t5/QlikView/getting-last-value-within-YTD-60-day-range/m-p/373928#M1175753 <HTML><HEAD></HEAD><BODY><P> Anyone?<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 30 May 2012 13:00:52 GMT https://community.qlik.com/t5/QlikView/getting-last-value-within-YTD-60-day-range/m-p/373928#M1175753 2012-05-30T13:00:52Z