topic Select OnActiveSheet in QlikView https://community.qlik.com/t5/QlikView/Select-OnActiveSheet/m-p/204298#M61270 <HTML><HEAD></HEAD><BODY><P>Hi hoping someone can help.</P><P>I have a selction box on my report that uses =MonthStart(MonthStart(DateCreated)) i would like it so when this sheet is selected it automaticly selcts the Max date.</P><P>On the Sheet Properties i have slected ONActiveSheet Selct Field. The field =DateCreated and the Search String =Max(MonthStart(DateCreated)) but clicking on off and the sheet doesnt make it select the latest month.</P><P>Any ideas?</P><P>Many Thanks</P><P>Gez</P></BODY></HTML> Thu, 07 Jan 2010 15:04:51 GMT 2010-01-07T15:04:51Z Select OnActiveSheet https://community.qlik.com/t5/QlikView/Select-OnActiveSheet/m-p/204298#M61270 <HTML><HEAD></HEAD><BODY><P>Hi hoping someone can help.</P><P>I have a selction box on my report that uses =MonthStart(MonthStart(DateCreated)) i would like it so when this sheet is selected it automaticly selcts the Max date.</P><P>On the Sheet Properties i have slected ONActiveSheet Selct Field. The field =DateCreated and the Search String =Max(MonthStart(DateCreated)) but clicking on off and the sheet doesnt make it select the latest month.</P><P>Any ideas?</P><P>Many Thanks</P><P>Gez</P></BODY></HTML> Thu, 07 Jan 2010 15:04:51 GMT https://community.qlik.com/t5/QlikView/Select-OnActiveSheet/m-p/204298#M61270 2010-01-07T15:04:51Z Select OnActiveSheet https://community.qlik.com/t5/QlikView/Select-OnActiveSheet/m-p/204299#M61271 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>see the attached example for more help.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 07 Jan 2010 15:49:35 GMT https://community.qlik.com/t5/QlikView/Select-OnActiveSheet/m-p/204299#M61271 2010-01-07T15:49:35Z