topic Re: How to Join to first row qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-Join-to-first-row-qlikview/m-p/986014#M948210 <HTML><HEAD></HEAD><BODY><P>Add one more line</P><P>Drop Table OC;</P></BODY></HTML> Fri, 25 Dec 2015 08:55:29 GMT MK_QSL 2015-12-25T08:55:29Z How to Join to first row qlikview https://community.qlik.com/t5/QlikView/How-to-Join-to-first-row-qlikview/m-p/986013#M948209 <HTML><HEAD></HEAD><BODY><P>I have the follwoing script </P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14510318290966812" jivemacro_uid="_14510318290966812"> <P>sales :</P> <P>Load *</P> <P></P> <P>from test.qvd ;</P> <P></P> <P>LEFT&nbsp; JOIN(<SPAN style="font-size: 13.3333px;">sales </SPAN>)</P> <P>IntervalMatch (datecol)</P> <P>LOAD DISTINCT [DATE DEBUT]</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,[DATE FIN]</P> <P> resident&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OC</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LEFT JOIN (<SPAN style="font-size: 13.3333px;">sales </SPAN>)</P> <P>LOAD *</P> <P>RESIDENT OC;</P> </PRE><P></P><P>I got duplicates rows . so how to Join to first row in qlikview ?</P></BODY></HTML> Fri, 25 Dec 2015 08:24:22 GMT https://community.qlik.com/t5/QlikView/How-to-Join-to-first-row-qlikview/m-p/986013#M948209 Anonymous 2015-12-25T08:24:22Z Re: How to Join to first row qlikview https://community.qlik.com/t5/QlikView/How-to-Join-to-first-row-qlikview/m-p/986014#M948210 <HTML><HEAD></HEAD><BODY><P>Add one more line</P><P>Drop Table OC;</P></BODY></HTML> Fri, 25 Dec 2015 08:55:29 GMT https://community.qlik.com/t5/QlikView/How-to-Join-to-first-row-qlikview/m-p/986014#M948210 MK_QSL 2015-12-25T08:55:29Z