topic How to get the latest value? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171654#M41574 <HTML><HEAD></HEAD><BODY><P>check attached qvw file......</P></BODY></HTML> Fri, 05 Nov 2010 16:53:09 GMT 2010-11-05T16:53:09Z How to get the latest value? https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171652#M41572 <HTML><HEAD></HEAD><BODY><P>Hi guys</P><P>Please see attached excel sheet.</P><P>I have products which has been receipted at different dates and at different costs.</P><P>I have used the following Expression to calculate the cost at which a product was receipted for a specific month.</P><P></P><P>((sum({$&lt;Year = {$(=max(Year) - $(=if(max(Month) = 1, 1, 0)))}, Month = {$(=month(addmonths(max(MonthYear), -1)))}&gt;} LineTotal))/</P><P>(sum({$&lt;Year = {$(=max(Year) - $(=if(max(Month) = 1, 1, 0)))}, Month = {$(=month(addmonths(max(MonthYear), -1)))}&gt;} (Quantity*BVolume))))*(BVolume)</P><P>Now I have a very neat table that shows me the breakdowns per month as you will see on the Excel sheet.</P><P>What I want to know, is there a way that Qlikview can show me that latest cost. In other words, Qlikview will have to look in which month the product was last receipted.</P><P>Thus for example: If there is no value in November, it must give me the value of October etc.</P><P></P><P>Any help would be appreciated.</P><P>Regards</P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><P></P></BODY></HTML> Thu, 04 Nov 2010 09:34:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171652#M41572 2010-11-04T09:34:21Z How to get the latest value? https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171653#M41573 <HTML><HEAD></HEAD><BODY><P>Please find attached the solution[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3225.latestvalue_5F00_solution.zip:550:0]</P></BODY></HTML> Fri, 05 Nov 2010 15:23:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171653#M41573 2010-11-05T15:23:30Z How to get the latest value? https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171654#M41574 <HTML><HEAD></HEAD><BODY><P>check attached qvw file......</P></BODY></HTML> Fri, 05 Nov 2010 16:53:09 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-latest-value/m-p/171654#M41574 2010-11-05T16:53:09Z