https://community.qlik.com/t5/App-Development/Filter-by-max-value/m-p/2021326#M84314 <P>Hello everyone! I am currently struggling with filtering the data in the table. I have created an example of my data in Excel and it looks like the following.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HelenaBow12__0-1672753149055.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/97155i59B720E8A0E6C897/image-size/medium?v=v2&amp;px=400" role="button" title="HelenaBow12__0-1672753149055.png" alt="HelenaBow12__0-1672753149055.png" /></span></P> <P>I now need to filter the strings by the highest revision number. So, my final table looks like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HelenaBow12__1-1672753266260.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/97156i9A1235F086CFB708/image-size/medium?v=v2&amp;px=400" role="button" title="HelenaBow12__1-1672753266260.png" alt="HelenaBow12__1-1672753266260.png" /></span></P> <P>I am new to Qlik, so I am not quite sure how to perform this.&nbsp;</P> <P>&nbsp;</P> <P>Thank you in advance for your ideas!</P> <P>&nbsp;</P> Tue, 03 Jan 2023 13:44:56 GMT HelenaBow12_ 2023-01-03T13:44:56Z https://community.qlik.com/t5/App-Development/Filter-by-max-value/m-p/2021326#M84314 <P>Hello everyone! I am currently struggling with filtering the data in the table. I have created an example of my data in Excel and it looks like the following.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HelenaBow12__0-1672753149055.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/97155i59B720E8A0E6C897/image-size/medium?v=v2&amp;px=400" role="button" title="HelenaBow12__0-1672753149055.png" alt="HelenaBow12__0-1672753149055.png" /></span></P> <P>I now need to filter the strings by the highest revision number. So, my final table looks like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="HelenaBow12__1-1672753266260.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/97156i9A1235F086CFB708/image-size/medium?v=v2&amp;px=400" role="button" title="HelenaBow12__1-1672753266260.png" alt="HelenaBow12__1-1672753266260.png" /></span></P> <P>I am new to Qlik, so I am not quite sure how to perform this.&nbsp;</P> <P>&nbsp;</P> <P>Thank you in advance for your ideas!</P> <P>&nbsp;</P> Tue, 03 Jan 2023 13:44:56 GMT https://community.qlik.com/t5/App-Development/Filter-by-max-value/m-p/2021326#M84314 HelenaBow12_ 2023-01-03T13:44:56Z https://community.qlik.com/t5/App-Development/Filter-by-max-value/m-p/2021350#M84315 <P>One front end approach could be as follows.</P> <P>Dimension: OfficeID, SalesPerson, ExpectedOrderDate and Revision</P> <P>Use the expression below for the Amount.</P> <P><STRONG>=Sum(Aggr(FirstSortedValue(Amount,-Revision),OfficeID))</STRONG></P> Tue, 03 Jan 2023 14:54:52 GMT https://community.qlik.com/t5/App-Development/Filter-by-max-value/m-p/2021350#M84315 BrunPierre 2023-01-03T14:54:52Z