topic last record by date range in App Development https://community.qlik.com/t5/App-Development/last-record-by-date-range/m-p/1548344#M39474 <P>Hi,</P><P>Please help me!!!!!!.... I want to get the last record of city&nbsp; by date range. Example:</P><P>I have this information:</P><TABLE><TBODY><TR><TD>vehicle model</TD><TD>city</TD><TD>DATE</TD></TR><TR><TD>AAA</TD><TD>A1</TD><TD>1/2/2017</TD></TR><TR><TD>AAA</TD><TD>A2</TD><TD>28/2/2017</TD></TR><TR><TD>AAA</TD><TD>A3</TD><TD>23/2/2019</TD></TR><TR><TD>BBB</TD><TD>B1</TD><TD>18/2/2017</TD></TR><TR><TD>BBB</TD><TD>B2</TD><TD>23/3/2018</TD></TR><TR><TD>BBB</TD><TD>B3</TD><TD>17/2/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and when I choose one date, for example <STRONG>23/3/2018 (rate of dates less or equal to the current selection)</STRONG> the result should be:</P><P><STRONG>DATE&nbsp;23/3/2018</STRONG></P><TABLE><TBODY><TR><TD>vehicle model</TD><TD>city</TD></TR><TR><TD>AAA</TD><TD>A2</TD></TR><TR><TD>BBB</TD><TD>B2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>if i select this DATE&nbsp;23/2/2019</STRONG></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>vehicle model</TD><TD>city</TD></TR><TR><TD>AAA</TD><TD>A3</TD></TR><TR><TD>BBB</TD><TD>B3</TD></TR></TBODY></TABLE><P>&nbsp;</P> Tue, 21 Dec 2021 20:15:22 GMT olguita2014 2021-12-21T20:15:22Z last record by date range https://community.qlik.com/t5/App-Development/last-record-by-date-range/m-p/1548344#M39474 <P>Hi,</P><P>Please help me!!!!!!.... I want to get the last record of city&nbsp; by date range. Example:</P><P>I have this information:</P><TABLE><TBODY><TR><TD>vehicle model</TD><TD>city</TD><TD>DATE</TD></TR><TR><TD>AAA</TD><TD>A1</TD><TD>1/2/2017</TD></TR><TR><TD>AAA</TD><TD>A2</TD><TD>28/2/2017</TD></TR><TR><TD>AAA</TD><TD>A3</TD><TD>23/2/2019</TD></TR><TR><TD>BBB</TD><TD>B1</TD><TD>18/2/2017</TD></TR><TR><TD>BBB</TD><TD>B2</TD><TD>23/3/2018</TD></TR><TR><TD>BBB</TD><TD>B3</TD><TD>17/2/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and when I choose one date, for example <STRONG>23/3/2018 (rate of dates less or equal to the current selection)</STRONG> the result should be:</P><P><STRONG>DATE&nbsp;23/3/2018</STRONG></P><TABLE><TBODY><TR><TD>vehicle model</TD><TD>city</TD></TR><TR><TD>AAA</TD><TD>A2</TD></TR><TR><TD>BBB</TD><TD>B2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P><STRONG>if i select this DATE&nbsp;23/2/2019</STRONG></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>vehicle model</TD><TD>city</TD></TR><TR><TD>AAA</TD><TD>A3</TD></TR><TR><TD>BBB</TD><TD>B3</TD></TR></TBODY></TABLE><P>&nbsp;</P> Tue, 21 Dec 2021 20:15:22 GMT https://community.qlik.com/t5/App-Development/last-record-by-date-range/m-p/1548344#M39474 olguita2014 2021-12-21T20:15:22Z