https://community.qlik.com/t5/Connectivity-Data-Prep/date-interval/m-p/1815752#M9158 <P>Hi&nbsp;</P><P>Try with firstsortedvalue function something like below</P><P>Temp2:<BR />Load * Inline<BR />[<BR />ID, Date_Start, Date_End<BR />66, 22.03.2021, 03.04.2021<BR />70, 28.03.2021, 30.03.2021<BR />];</P><P>Inner Join<BR />Load FirstSortedValue(ID, Interval(Date_Start-Date_End)) as ID Resident Temp2;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1623925982277.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56971i9DD4ED19635FD79D/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1623925982277.png" alt="MayilVahanan_0-1623925982277.png" /></span></P><P>&nbsp;</P> Thu, 17 Jun 2021 10:33:36 GMT MayilVahanan 2021-06-17T10:33:36Z https://community.qlik.com/t5/Connectivity-Data-Prep/date-interval/m-p/1815689#M9157 <P>Hello.there is a date_start and date_end of one row and a second. If one interval is larger than the other, the result is the row with the largest interval. please help me</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Nextle_0-1623918469244.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56933i9FAC0761093B9241/image-size/medium?v=v2&amp;px=400" role="button" title="Nextle_0-1623918469244.png" alt="Nextle_0-1623918469244.png" /></span></P><P>result:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Nextle_1-1623918525501.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56934iACEF918763555643/image-size/medium?v=v2&amp;px=400" role="button" title="Nextle_1-1623918525501.png" alt="Nextle_1-1623918525501.png" /></span></P><P>thank you in advance.</P> Thu, 17 Jun 2021 08:29:17 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/date-interval/m-p/1815689#M9157 Nextle 2021-06-17T08:29:17Z https://community.qlik.com/t5/Connectivity-Data-Prep/date-interval/m-p/1815752#M9158 <P>Hi&nbsp;</P><P>Try with firstsortedvalue function something like below</P><P>Temp2:<BR />Load * Inline<BR />[<BR />ID, Date_Start, Date_End<BR />66, 22.03.2021, 03.04.2021<BR />70, 28.03.2021, 30.03.2021<BR />];</P><P>Inner Join<BR />Load FirstSortedValue(ID, Interval(Date_Start-Date_End)) as ID Resident Temp2;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="MayilVahanan_0-1623925982277.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/56971i9DD4ED19635FD79D/image-size/medium?v=v2&amp;px=400" role="button" title="MayilVahanan_0-1623925982277.png" alt="MayilVahanan_0-1623925982277.png" /></span></P><P>&nbsp;</P> Thu, 17 Jun 2021 10:33:36 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/date-interval/m-p/1815752#M9158 MayilVahanan 2021-06-17T10:33:36Z