https://community.qlik.com/t5/App-Development/Current-month-on-the-load-of-Sheet/m-p/2000918#M82896 <P>Field = Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String Search = Max({1}Year)<BR />Field = Month&nbsp;&nbsp;&nbsp;&nbsp; String Search = MaxString({1&lt;Year = {$(=Max({1}Year))}&gt;}Month)</P> Sat, 05 Nov 2022 09:23:37 GMT BrunPierre 2022-11-05T09:23:37Z https://community.qlik.com/t5/App-Development/Current-month-on-the-load-of-Sheet/m-p/2000885#M82889 <P>Hi - I am creating Sheet properties &gt; Action to open on last month (for example: Sep). However, it is not opening to September month values.</P> <P>Label &gt; Open</P> <P>Action &gt; Select Values in a field</P> <P>Field &gt; VRT_Month</P> <P><SPAN>Value &gt; ='Sep'</SPAN></P> <P>Any help is greatly appreciated.</P> <P><BR />Thank You</P> <P>Muralidhar</P> <P>&nbsp;</P> Fri, 04 Nov 2022 21:43:02 GMT https://community.qlik.com/t5/App-Development/Current-month-on-the-load-of-Sheet/m-p/2000885#M82889 Muralidhar 2022-11-04T21:43:02Z https://community.qlik.com/t5/App-Development/Current-month-on-the-load-of-Sheet/m-p/2000918#M82896 <P>Field = Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String Search = Max({1}Year)<BR />Field = Month&nbsp;&nbsp;&nbsp;&nbsp; String Search = MaxString({1&lt;Year = {$(=Max({1}Year))}&gt;}Month)</P> Sat, 05 Nov 2022 09:23:37 GMT https://community.qlik.com/t5/App-Development/Current-month-on-the-load-of-Sheet/m-p/2000918#M82896 BrunPierre 2022-11-05T09:23:37Z