topic Re: How to get Max Financial quarter dynamically in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Max-Financial-quarter-dynamically/m-p/407011#M488386 <HTML><HEAD></HEAD><BODY><P>for the first part try:</P><P></P><P>= MaxString({$&lt;[Year]= {$(=MaxString([Year]))}&gt;}[Quarter]) </P><P></P><P>I cant see anything wrong with the syntax for the second part:</P><P></P><P>Mid(MaxString([Year]),3,2)</P></BODY></HTML> Wed, 09 Jan 2013 10:24:19 GMT adamwilson 2013-01-09T10:24:19Z How to get Max Financial quarter dynamically https://community.qlik.com/t5/QlikView/How-to-get-Max-Financial-quarter-dynamically/m-p/407010#M488385 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am using the the expression which is not working </P><P>=MaxString({$&lt;[Year]=MaxString([Year])&gt;}[Quarter]) &amp;Mid(MaxString([Year]),3,2)</P><P>could you please let me known how to slove my problem?</P><P></P><P>Thanks</P></BODY></HTML> Wed, 09 Jan 2013 09:48:08 GMT https://community.qlik.com/t5/QlikView/How-to-get-Max-Financial-quarter-dynamically/m-p/407010#M488385 2013-01-09T09:48:08Z Re: How to get Max Financial quarter dynamically https://community.qlik.com/t5/QlikView/How-to-get-Max-Financial-quarter-dynamically/m-p/407011#M488386 <HTML><HEAD></HEAD><BODY><P>for the first part try:</P><P></P><P>= MaxString({$&lt;[Year]= {$(=MaxString([Year]))}&gt;}[Quarter]) </P><P></P><P>I cant see anything wrong with the syntax for the second part:</P><P></P><P>Mid(MaxString([Year]),3,2)</P></BODY></HTML> Wed, 09 Jan 2013 10:24:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-Max-Financial-quarter-dynamically/m-p/407011#M488386 adamwilson 2013-01-09T10:24:19Z