topic Select Max in Load Statement in QlikView https://community.qlik.com/t5/QlikView/Select-Max-in-Load-Statement/m-p/293928#M1200929 <HTML><HEAD></HEAD><BODY><P>Nevermind,</P><P>Looks like one of the other current posts had a very similar problem.</P><P></P><P>Looks like all I was missing was</P><P style="font-style: italic">Inner Join</P><P>Load [Special Key], max([Revision No]) as [Max Revision No], NPI<BR />Resident NPI<BR />Group By [Special Key], NPI;</P></BODY></HTML> Tue, 14 Dec 2010 21:37:44 GMT kkorynta 2010-12-14T21:37:44Z Select Max in Load Statement https://community.qlik.com/t5/QlikView/Select-Max-in-Load-Statement/m-p/293927#M1200928 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a list that includes revision numbers. I'd like to 'roll up' the data in the load statement so only the current versions are selected.</P><P></P><P>I thought it would be something along the lines of</P><P>NoConcatenate Load [Special Key], max([Revision No]) as [Max Revision No], NPI<BR />Resident NPI<BR />Group By [Special Key], NPI;</P><P>But this doesn't seem to be the case.</P><P></P><P>Any idea where I'm going wrong?</P><P></P><P>Thanks!</P><P></P></BODY></HTML> Tue, 14 Dec 2010 21:22:07 GMT https://community.qlik.com/t5/QlikView/Select-Max-in-Load-Statement/m-p/293927#M1200928 kkorynta 2010-12-14T21:22:07Z Select Max in Load Statement https://community.qlik.com/t5/QlikView/Select-Max-in-Load-Statement/m-p/293928#M1200929 <HTML><HEAD></HEAD><BODY><P>Nevermind,</P><P>Looks like one of the other current posts had a very similar problem.</P><P></P><P>Looks like all I was missing was</P><P style="font-style: italic">Inner Join</P><P>Load [Special Key], max([Revision No]) as [Max Revision No], NPI<BR />Resident NPI<BR />Group By [Special Key], NPI;</P></BODY></HTML> Tue, 14 Dec 2010 21:37:44 GMT https://community.qlik.com/t5/QlikView/Select-Max-in-Load-Statement/m-p/293928#M1200929 kkorynta 2010-12-14T21:37:44Z