topic Re: How to pick the most recent month ? in QlikView https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126620#M890764 <HTML><HEAD></HEAD><BODY><P>Hi Pavana,</P><P></P><P>The answer is found in this post:</P><P></P><P><A href="https://community.qlik.com/thread/212852">Get Max Date and Max Value of a ID</A></P><P></P><P>Cheers,</P><P>Paul</P></BODY></HTML> Wed, 17 Aug 2016 14:52:29 GMT pk2019 2016-08-17T14:52:29Z How to pick the most recent month ? https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126619#M890763 <HTML><HEAD></HEAD><BODY><P>PFA Sample QVW.How to pick the most recent month for each ID? </P><P></P><P>Thanks much.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126619#M890763 2020-11-25T16:16:04Z Re: How to pick the most recent month ? https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126620#M890764 <HTML><HEAD></HEAD><BODY><P>Hi Pavana,</P><P></P><P>The answer is found in this post:</P><P></P><P><A href="https://community.qlik.com/thread/212852">Get Max Date and Max Value of a ID</A></P><P></P><P>Cheers,</P><P>Paul</P></BODY></HTML> Wed, 17 Aug 2016 14:52:29 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126620#M890764 pk2019 2016-08-17T14:52:29Z Re: How to pick the most recent month ? https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126621#M890765 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>=FirstSortedValue( aggr(sum(Amount),[Invoice Month],Code), aggr(-max(match([Invoice Month], 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') ),[Invoice Month],Code))*12</P><P></P><P>Alternatively replace your textual month field with a field that has a numeric value. That way you can replace the max(match(... )) construction with the name of the numeric field.</P></BODY></HTML> Wed, 17 Aug 2016 14:56:49 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126621#M890765 Gysbert_Wassenaar 2016-08-17T14:56:49Z Re: How to pick the most recent month ? https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126622#M890766 <HTML><HEAD></HEAD><BODY><P>A slightly different way to assign numerical value to month:</P><P></P><P><STRONG>=FirstSortedValue(Aggr(Sum(Amount), [Invoice Month], Code), -Aggr(Max(<SPAN style="color: #ff0000;">Date#([Invoice Month], 'MMM')</SPAN>), [Invoice Month], Code)) * 12</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG __jive_id="134811" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/134811_Capture.PNG" style="height: auto;" /><BR /></STRONG></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Thu, 18 Aug 2016 01:53:56 GMT https://community.qlik.com/t5/QlikView/How-to-pick-the-most-recent-month/m-p/1126622#M890766 sunny_talwar 2016-08-18T01:53:56Z