topic Re: Delete rows in QlikView https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347402#M846261 <HTML><HEAD></HEAD><BODY><P>Sorry, for my late reply!</P><P>Thanks al lot! That's exactly what I needed.</P><P>Great!</P></BODY></HTML> Thu, 13 Apr 2017 09:46:53 GMT Anonymous 2017-04-13T09:46:53Z Delete rows https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347400#M846259 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I've the following Table</P><P></P><P></P><P>Productname - Date1 - Partname - Date2 </P><P></P><P>ProductA - 02.02.2013 - 25.02.2014&nbsp;&nbsp;&nbsp; </P><P>ProductA - 02.02.2013&nbsp; - 10.10.2016</P><P>ProductA - 21.08.2014 - 21.08.2014</P><P>ProductB - 05.05.2012 - 16.08.2016</P><P>ProductC&nbsp; 15.05.2012 - 29.03.2015</P><P>ProductC&nbsp; 15.05.2012 - 01.01.2014</P><P></P><P>But I only need the rows with the closest Date2 to Date1:</P><P>ProductA - 02.02.2013 - 25.02.2014&nbsp;&nbsp;&nbsp;&nbsp; </P><P>ProductA - 21.08.2014 - 21.08.2014</P><P>ProductB - 05.05.2012 - 16.08.2016</P><P>roductC&nbsp; 15.05.2012 - 01.01.2014</P><P></P><P>Thankx</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347400#M846259 Anonymous 2020-11-25T16:16:04Z Re: Delete rows https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347401#M846260 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; Date2 - Date1 as Diff;</STRONG></P><P><STRONG>LOAD * INLINE [</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; Productname , Date1, Date2</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ProductA , 02.02.2013 , 25.02.2014&nbsp; </STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ProductA , 02.02.2013&nbsp; , 10.10.2016</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ProductA , 21.08.2014 , 21.08.2014</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ProductB , 05.05.2012 , 16.08.2016</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ProductC,&nbsp; 15.05.2012 , 29.03.2015</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp; ProductC,&nbsp; 15.05.2012 , 01.01.2014</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Right Join (Table)</STRONG></P><P><STRONG>LOAD Productname,</STRONG></P><P><STRONG>&nbsp; Date1,</STRONG></P><P><STRONG>&nbsp; Min(Diff) as Diff</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Group By Productname, Date1;</STRONG></P></BODY></HTML> Wed, 05 Apr 2017 15:24:02 GMT https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347401#M846260 sunny_talwar 2017-04-05T15:24:02Z Re: Delete rows https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347402#M846261 <HTML><HEAD></HEAD><BODY><P>Sorry, for my late reply!</P><P>Thanks al lot! That's exactly what I needed.</P><P>Great!</P></BODY></HTML> Thu, 13 Apr 2017 09:46:53 GMT https://community.qlik.com/t5/QlikView/Delete-rows/m-p/1347402#M846261 Anonymous 2017-04-13T09:46:53Z