topic join in QlikView https://community.qlik.com/t5/QlikView/join/m-p/173510#M1311844 <HTML><HEAD></HEAD><BODY><P>Do not know, whether I understood your question right: You want to load only those values, where EYear is lowest? You may join an indicator for the smallest EYear and the filter for it:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">JOIN pname, MIN(EYear) AS EYear, 'min' AS indicator RESIDENT p GROUP BY pname, EYear;<BR />mp: LOAD pname, EYear RESIDENT p WHERE indicator = 'min'; DROP TABLE p;</PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Sun, 22 Nov 2009 02:29:36 GMT prieper 2009-11-22T02:29:36Z join https://community.qlik.com/t5/QlikView/join/m-p/173509#M1311842 <HTML><HEAD></HEAD><BODY><P>hi</P><P>how can i write this in qlikview?</P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <BR /><BR /> <P style="font-weight: bold"></P><P style="font-weight: bold">minp: load</P><B></B><P style="font-weight: bold"></P><P></P><P>load pr , Eyear from p;</P>pname ,min(EYear) <B>as</B> MinEYear <B>resident</B> p <B>group</B> <B>by</B> pname; <BR /><BR /> <P>load if (EYear= MinEYear ,pr) resident p , minp ;</P><P></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/join/m-p/173509#M1311842 2026-01-26T18:19:17Z join https://community.qlik.com/t5/QlikView/join/m-p/173510#M1311844 <HTML><HEAD></HEAD><BODY><P>Do not know, whether I understood your question right: You want to load only those values, where EYear is lowest? You may join an indicator for the smallest EYear and the filter for it:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">JOIN pname, MIN(EYear) AS EYear, 'min' AS indicator RESIDENT p GROUP BY pname, EYear;<BR />mp: LOAD pname, EYear RESIDENT p WHERE indicator = 'min'; DROP TABLE p;</PRE></BLOCKQUOTE><BR /><BR /> <P>HTH<BR />Peter</P></BODY></HTML> Sun, 22 Nov 2009 02:29:36 GMT https://community.qlik.com/t5/QlikView/join/m-p/173510#M1311844 prieper 2009-11-22T02:29:36Z