topic Re: Select last day with data in QlikView https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868970#M303896 <HTML><HEAD></HEAD><BODY><P>Use on open document trigger or button actions</P><P>Action --&gt; Select in Field</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field Name = DATE</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Value = Max({1}DATE)</P><P></P><P>Hope it helps</P><P>Celambarasan</P></BODY></HTML> Mon, 04 May 2015 08:11:04 GMT CELAMBARASAN 2015-05-04T08:11:04Z Select last day with data https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868968#M303894 <HTML><HEAD></HEAD><BODY><P>I want to put a trigger to select last day with available data. </P><P></P><P>I have&nbsp; DATE dimension with year-month-day</P><P>How I can do? Thank you.</P><P></P><P>Greetings .</P></BODY></HTML> Mon, 04 May 2015 08:05:46 GMT https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868968#M303894 2015-05-04T08:05:46Z Re: Select last day with data https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868969#M303895 <HTML><HEAD></HEAD><BODY><P>Last day mean max available date in your data correct ?</P></BODY></HTML> Mon, 04 May 2015 08:10:12 GMT https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868969#M303895 Anonymous 2015-05-04T08:10:12Z Re: Select last day with data https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868970#M303896 <HTML><HEAD></HEAD><BODY><P>Use on open document trigger or button actions</P><P>Action --&gt; Select in Field</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field Name = DATE</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Value = Max({1}DATE)</P><P></P><P>Hope it helps</P><P>Celambarasan</P></BODY></HTML> Mon, 04 May 2015 08:11:04 GMT https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868970#M303896 CELAMBARASAN 2015-05-04T08:11:04Z Re: Select last day with data https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868971#M303897 <HTML><HEAD></HEAD><BODY><P>Thank you Celambarasan</P></BODY></HTML> Mon, 04 May 2015 10:21:03 GMT https://community.qlik.com/t5/QlikView/Select-last-day-with-data/m-p/868971#M303897 2015-05-04T10:21:03Z