topic How can i get max date and last values? in QlikView https://community.qlik.com/t5/QlikView/How-can-i-get-max-date-and-last-values/m-p/174856#M501912 <HTML><HEAD></HEAD><BODY><P>Hi, i have an Historic table with records like:</P><P>ID USER H_DATE SITUATION REASON<BR />01 1 10/01/10 ENABLED NEW<BR />02 2 02/02/10 ENABLED NEW<BR />03 3 03/02/10 ENABLED RETURN<BR />04 1 01/04/10 DISABLED HOLIDAY<BR />05 3 18/02/10 FIRED LEAVE<BR />06 1 01/05/10 ENABLED RETURN<BR />07 3 02/05/10 ENABLED RETURN<BR />08 2 01/07/10 DISABLED SICK<BR />09 3 05/08/10 DISABLED HOLIDAY<BR />10 1 05/09/10 TRANSFER NEW DESTINATION<BR />11 2 06/09/10 ENABLED CURE<BR />12 1 08/09/10 ENABLED RETURN<BR />13 3 10/09/10 ENABLED RETURN</P><P>I need that when selected the SITUATION = ENABLED and filter the DATE &lt; 01/09/10 the obteined data group by USER must be:</P><P>P.S: the date filter is very important and i done into the load script with: where date(H_DATE,'DD/MM/YYYY') &lt; date($(vLastDate),'DD/MM/YYYY')</P><P>ID USER H_DATE SITUATION REASON<BR />06 1 01/05/10 ENABLED RETURN<BR />02 2 02/02/10 ENABLED NEW<BR />07 3 02/05/10 ENABLED RETURN</P><P>Sorry for my poor english, but i hope you can help me!</P><P>Thanks!!</P></BODY></HTML> Sun, 07 Nov 2010 18:20:00 GMT 2010-11-07T18:20:00Z How can i get max date and last values? https://community.qlik.com/t5/QlikView/How-can-i-get-max-date-and-last-values/m-p/174856#M501912 <HTML><HEAD></HEAD><BODY><P>Hi, i have an Historic table with records like:</P><P>ID USER H_DATE SITUATION REASON<BR />01 1 10/01/10 ENABLED NEW<BR />02 2 02/02/10 ENABLED NEW<BR />03 3 03/02/10 ENABLED RETURN<BR />04 1 01/04/10 DISABLED HOLIDAY<BR />05 3 18/02/10 FIRED LEAVE<BR />06 1 01/05/10 ENABLED RETURN<BR />07 3 02/05/10 ENABLED RETURN<BR />08 2 01/07/10 DISABLED SICK<BR />09 3 05/08/10 DISABLED HOLIDAY<BR />10 1 05/09/10 TRANSFER NEW DESTINATION<BR />11 2 06/09/10 ENABLED CURE<BR />12 1 08/09/10 ENABLED RETURN<BR />13 3 10/09/10 ENABLED RETURN</P><P>I need that when selected the SITUATION = ENABLED and filter the DATE &lt; 01/09/10 the obteined data group by USER must be:</P><P>P.S: the date filter is very important and i done into the load script with: where date(H_DATE,'DD/MM/YYYY') &lt; date($(vLastDate),'DD/MM/YYYY')</P><P>ID USER H_DATE SITUATION REASON<BR />06 1 01/05/10 ENABLED RETURN<BR />02 2 02/02/10 ENABLED NEW<BR />07 3 02/05/10 ENABLED RETURN</P><P>Sorry for my poor english, but i hope you can help me!</P><P>Thanks!!</P></BODY></HTML> Sun, 07 Nov 2010 18:20:00 GMT https://community.qlik.com/t5/QlikView/How-can-i-get-max-date-and-last-values/m-p/174856#M501912 2010-11-07T18:20:00Z How can i get max date and last values? https://community.qlik.com/t5/QlikView/How-can-i-get-max-date-and-last-values/m-p/174857#M501913 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Check <A href="http://community.qlik.com/media/p/143017.aspx" target="_blank" title="The Basics about Dates, Date Ranges and Set Analysis">this file</A>. Hope that helps.</P><P>Regards.</P></BODY></HTML> Sun, 07 Nov 2010 19:32:44 GMT https://community.qlik.com/t5/QlikView/How-can-i-get-max-date-and-last-values/m-p/174857#M501913 Miguel_Angel_Baeyens 2010-11-07T19:32:44Z