topic Groupby with max date in App Development https://community.qlik.com/t5/App-Development/Groupby-with-max-date/m-p/1612633#M45610 <P>Hey all, I am stuck in converting this data in one line -</P><P>I want to get the field values only associated with the Max Date of [FileNameDate], Group by [PKey]</P><TABLE><TBODY><TR><TD>PKey</TD><TD>WEIGHT</TD><TD>Service Level</TD><TD>UPG_CODE</TD><TD>FileNameDate</TD></TR><TR><TD>50242355891OLN0001</TD><TD>0.5</TD><TD>GROUND</TD><TD>MI/with ATP disabled</TD><TD>09/08/2019</TD></TR><TR><TD>50242355891OLN0001</TD><TD>1.4</TD><TD>GROUND</TD><TD>-</TD><TD>07/08/2019</TD></TR><TR><TD>50242355891OLN0001</TD><TD>0.5</TD><TD>GROUND</TD><TD>MI/with ATP disabled</TD><TD>08/08/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Result Should Look Like This: -&nbsp;</P><TABLE><TBODY><TR><TD>50242355891OLN0001</TD><TD>0.5</TD><TD>GROUND</TD><TD>MI/with ATP disabled</TD><TD>09/08/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Will really appreciate all help and opinions. Thanks a ton!</P> Sat, 16 Nov 2024 20:15:52 GMT yashpace 2024-11-16T20:15:52Z Groupby with max date https://community.qlik.com/t5/App-Development/Groupby-with-max-date/m-p/1612633#M45610 <P>Hey all, I am stuck in converting this data in one line -</P><P>I want to get the field values only associated with the Max Date of [FileNameDate], Group by [PKey]</P><TABLE><TBODY><TR><TD>PKey</TD><TD>WEIGHT</TD><TD>Service Level</TD><TD>UPG_CODE</TD><TD>FileNameDate</TD></TR><TR><TD>50242355891OLN0001</TD><TD>0.5</TD><TD>GROUND</TD><TD>MI/with ATP disabled</TD><TD>09/08/2019</TD></TR><TR><TD>50242355891OLN0001</TD><TD>1.4</TD><TD>GROUND</TD><TD>-</TD><TD>07/08/2019</TD></TR><TR><TD>50242355891OLN0001</TD><TD>0.5</TD><TD>GROUND</TD><TD>MI/with ATP disabled</TD><TD>08/08/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Result Should Look Like This: -&nbsp;</P><TABLE><TBODY><TR><TD>50242355891OLN0001</TD><TD>0.5</TD><TD>GROUND</TD><TD>MI/with ATP disabled</TD><TD>09/08/2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Will really appreciate all help and opinions. Thanks a ton!</P> Sat, 16 Nov 2024 20:15:52 GMT https://community.qlik.com/t5/App-Development/Groupby-with-max-date/m-p/1612633#M45610 yashpace 2024-11-16T20:15:52Z Re: Groupby with max date https://community.qlik.com/t5/App-Development/Groupby-with-max-date/m-p/1612642#M45611 <P>Hi&nbsp;</P><P>I hope you find this useful</P> Wed, 14 Aug 2019 21:07:19 GMT https://community.qlik.com/t5/App-Development/Groupby-with-max-date/m-p/1612642#M45611 CuauSR 2019-08-14T21:07:19Z