topic Maximum Year-Month to be get in a Variable in App Development https://community.qlik.com/t5/App-Development/Maximum-Year-Month-to-be-get-in-a-Variable/m-p/1244837#M24818 <HTML><HEAD></HEAD><BODY><P>Hi Team, </P><P></P><P>I have field [OriginYear-Month] Values are like, 2016-12,2016-11' - - - - 2014, these values getting from sqlserver,</P><P>Now requirement is , i need to pick latest year-Month(2016-12) dynamically from field to a variable, and i need to use that variable and evaluate some other months by using Addmonths Function.</P><P></P><P>i tried initially firstsortedvalue at that time i got solution, now its not working ,</P><P>Can any one suggest better solution for my requirment </P><P></P><P>Regards</P><P>suresh</P></BODY></HTML> Mon, 12 Dec 2016 09:42:16 GMT suresh_qv50 2016-12-12T09:42:16Z Maximum Year-Month to be get in a Variable https://community.qlik.com/t5/App-Development/Maximum-Year-Month-to-be-get-in-a-Variable/m-p/1244837#M24818 <HTML><HEAD></HEAD><BODY><P>Hi Team, </P><P></P><P>I have field [OriginYear-Month] Values are like, 2016-12,2016-11' - - - - 2014, these values getting from sqlserver,</P><P>Now requirement is , i need to pick latest year-Month(2016-12) dynamically from field to a variable, and i need to use that variable and evaluate some other months by using Addmonths Function.</P><P></P><P>i tried initially firstsortedvalue at that time i got solution, now its not working ,</P><P>Can any one suggest better solution for my requirment </P><P></P><P>Regards</P><P>suresh</P></BODY></HTML> Mon, 12 Dec 2016 09:42:16 GMT https://community.qlik.com/t5/App-Development/Maximum-Year-Month-to-be-get-in-a-Variable/m-p/1244837#M24818 suresh_qv50 2016-12-12T09:42:16Z Re: Maximum Year-Month to be get in a Variable https://community.qlik.com/t5/App-Development/Maximum-Year-Month-to-be-get-in-a-Variable/m-p/1244838#M24819 <HTML><HEAD></HEAD><BODY><P>Hi Suresh,</P><P></P><P>The best option I see is create a Year Month from this data using Monthname Function.</P><P></P><P>Something like below.</P><P></P><P>Monthname(Makedate(Left(Field,4),Right(Field,2))) as MonthYear.</P><P></P><P>Now you can simply use the Max function or Maxstring function to get the maximum month year.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 12 Dec 2016 09:48:00 GMT https://community.qlik.com/t5/App-Development/Maximum-Year-Month-to-be-get-in-a-Variable/m-p/1244838#M24819 kaushiknsolanki 2016-12-12T09:48:00Z