topic problem in max(Fiscalyear) in App Development https://community.qlik.com/t5/App-Development/problem-in-max-Fiscalyear/m-p/47542#M3235 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have table like this</P><P></P><P>FiscalYear</P><P>2016-2017</P><P>2017-2018</P><P>when i am trying below expression i am getting 26 </P><P>previously it was working fine.</P><P></P><P>right(max(FiscalYear),2)</P><P></P><P>it should give me 18 i.e my max(fiscalyear) is FY18</P><P></P><P>Please help.</P><P>i have attached image</P></BODY></HTML> Tue, 17 Apr 2018 09:05:46 GMT poojashribanger 2018-04-17T09:05:46Z problem in max(Fiscalyear) https://community.qlik.com/t5/App-Development/problem-in-max-Fiscalyear/m-p/47542#M3235 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have table like this</P><P></P><P>FiscalYear</P><P>2016-2017</P><P>2017-2018</P><P>when i am trying below expression i am getting 26 </P><P>previously it was working fine.</P><P></P><P>right(max(FiscalYear),2)</P><P></P><P>it should give me 18 i.e my max(fiscalyear) is FY18</P><P></P><P>Please help.</P><P>i have attached image</P></BODY></HTML> Tue, 17 Apr 2018 09:05:46 GMT https://community.qlik.com/t5/App-Development/problem-in-max-Fiscalyear/m-p/47542#M3235 poojashribanger 2018-04-17T09:05:46Z Re: problem in max(Fiscalyear) https://community.qlik.com/t5/App-Development/problem-in-max-Fiscalyear/m-p/47543#M3236 <HTML><HEAD></HEAD><BODY><P>May be try this</P><P></P><P><STRONG>Right(MaxString(FiscalYear), 2)</STRONG></P></BODY></HTML> Tue, 17 Apr 2018 09:08:22 GMT https://community.qlik.com/t5/App-Development/problem-in-max-Fiscalyear/m-p/47543#M3236 sunny_talwar 2018-04-17T09:08:22Z