topic Help with MaxString! in QlikView https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290221#M1185238 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>In one of our application. Month is considered as A1,A2..A12. To get the max of month in this format I have been using MaxString(MONTH). Looks like it is not working as expected as the max(MONTH) should be A10 but it is still displaying A9 as the max of month.</P><P></P><P>Please let me know what function will give the result that I need.</P><P></P><P>Thanks</P><P></P><P>Attitude</P></BODY></HTML> Mon, 26 Sep 2011 12:39:41 GMT 2011-09-26T12:39:41Z Help with MaxString! https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290221#M1185238 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>In one of our application. Month is considered as A1,A2..A12. To get the max of month in this format I have been using MaxString(MONTH). Looks like it is not working as expected as the max(MONTH) should be A10 but it is still displaying A9 as the max of month.</P><P></P><P>Please let me know what function will give the result that I need.</P><P></P><P>Thanks</P><P></P><P>Attitude</P></BODY></HTML> Mon, 26 Sep 2011 12:39:41 GMT https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290221#M1185238 2011-09-26T12:39:41Z Re: Help with MaxString! https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290222#M1185239 <HTML><HEAD></HEAD><BODY><P>see the attached file</P><P></P><P>hope this helps</P></BODY></HTML> Mon, 26 Sep 2011 12:55:53 GMT https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290222#M1185239 SunilChauhan 2011-09-26T12:55:53Z Help with MaxString! https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290223#M1185240 <HTML><HEAD></HEAD><BODY><P>Hi Sunil</P><P></P><P>Can you please do everything in the script level instead of using variable.</P><P></P><P>Thanks</P><P></P><P>Attitude</P></BODY></HTML> Mon, 26 Sep 2011 13:17:50 GMT https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290223#M1185240 2011-09-26T13:17:50Z Help with MaxString! https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290224#M1185241 <HTML><HEAD></HEAD><BODY><P> Hi All </P><P></P><P>If month contains A1,A2,A3,A4,A5,A6,A7,A8,A9 and A10. Function should return A10 as the max(month).</P><P></P><P>Thanks</P><P></P><P>Attitude</P></BODY></HTML> Mon, 26 Sep 2011 13:24:22 GMT https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290224#M1185241 2011-09-26T13:24:22Z Re: Help with MaxString! https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290225#M1185242 <HTML><HEAD></HEAD><BODY><P>see the attached file </P><P></P><P></P><P>hope it make you haapy</P></BODY></HTML> Mon, 26 Sep 2011 13:35:04 GMT https://community.qlik.com/t5/QlikView/Help-with-MaxString/m-p/290225#M1185242 SunilChauhan 2011-09-26T13:35:04Z