topic load serial, Max(log_date), logged_value in QlikView https://community.qlik.com/t5/QlikView/load-serial-Max-log-date-logged-value/m-p/494979#M185135 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need some help here.&nbsp; I have 3 fields: AC_SERIAL, LOG_DATE and LOG_VALUE.</P><P></P><P>I want to load in the max(log_date) for each aircraft and return the single log_value for that date.&nbsp; I need help.&nbsp; Thanks.</P></BODY></HTML> Wed, 14 Aug 2013 20:16:45 GMT 2013-08-14T20:16:45Z load serial, Max(log_date), logged_value https://community.qlik.com/t5/QlikView/load-serial-Max-log-date-logged-value/m-p/494979#M185135 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need some help here.&nbsp; I have 3 fields: AC_SERIAL, LOG_DATE and LOG_VALUE.</P><P></P><P>I want to load in the max(log_date) for each aircraft and return the single log_value for that date.&nbsp; I need help.&nbsp; Thanks.</P></BODY></HTML> Wed, 14 Aug 2013 20:16:45 GMT https://community.qlik.com/t5/QlikView/load-serial-Max-log-date-logged-value/m-p/494979#M185135 2013-08-14T20:16:45Z Re: load serial, Max(log_date), logged_value https://community.qlik.com/t5/QlikView/load-serial-Max-log-date-logged-value/m-p/494980#M185136 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>Load&nbsp;&nbsp;&nbsp;&nbsp; </P><P> AC_SERIAL , </P><P>max(LOG_DATE), </P><P>FirstSortedValue(LOG_VALUE, -LOG_DATE ) </P><P>FROM ... GROUP BY AC_SERIAL;</P><P></P><P></P></BODY></HTML> Wed, 14 Aug 2013 20:35:11 GMT https://community.qlik.com/t5/QlikView/load-serial-Max-log-date-logged-value/m-p/494980#M185136 swuehl 2013-08-14T20:35:11Z