https://community.qlik.com/t5/QlikView/Max-Value/m-p/1685494#M455797 <P>I am guessing you have VIN as your dimension, if you do, then try this as your measure</P><LI-CODE lang="markup">FirstSortedValue([Odometer Value], -[Transaction Date])</LI-CODE> Tue, 17 Mar 2020 19:12:56 GMT sunny_talwar 2020-03-17T19:12:56Z https://community.qlik.com/t5/QlikView/Max-Value/m-p/1685490#M455796 <P>I would like to take a column based on the max transaction date.&nbsp; I have a series of transaction dates and I want to know the odometer value per vin by the max transaction date for each vin.</P> Sat, 16 Nov 2024 01:02:06 GMT https://community.qlik.com/t5/QlikView/Max-Value/m-p/1685490#M455796 FrankC 2024-11-16T01:02:06Z https://community.qlik.com/t5/QlikView/Max-Value/m-p/1685494#M455797 <P>I am guessing you have VIN as your dimension, if you do, then try this as your measure</P><LI-CODE lang="markup">FirstSortedValue([Odometer Value], -[Transaction Date])</LI-CODE> Tue, 17 Mar 2020 19:12:56 GMT https://community.qlik.com/t5/QlikView/Max-Value/m-p/1685494#M455797 sunny_talwar 2020-03-17T19:12:56Z