topic Getting latest updated value in expression in QlikView https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470438#M175710 <HTML><HEAD></HEAD><BODY><P>How can I get the values from the latest update in an expression?</P><P></P><P>For the data below, I'd want my chart to show for ID=1, Value=110</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Change Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1/11/2012</TD><TD>100</TD></TR><TR><TD>1</TD><TD>3/11/2012</TD><TD>125</TD></TR><TR><TD>1</TD><TD>5/11/2012</TD><TD>75</TD></TR><TR><TD>1</TD><TD>10/11/2012</TD><TD>90</TD></TR><TR><TD>1</TD><TD>20/11/2012</TD><TD>110</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P></P><P>CJ</P></BODY></HTML> Tue, 27 Nov 2012 11:53:23 GMT 2012-11-27T11:53:23Z Getting latest updated value in expression https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470438#M175710 <HTML><HEAD></HEAD><BODY><P>How can I get the values from the latest update in an expression?</P><P></P><P>For the data below, I'd want my chart to show for ID=1, Value=110</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Change Date</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Value</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>1/11/2012</TD><TD>100</TD></TR><TR><TD>1</TD><TD>3/11/2012</TD><TD>125</TD></TR><TR><TD>1</TD><TD>5/11/2012</TD><TD>75</TD></TR><TR><TD>1</TD><TD>10/11/2012</TD><TD>90</TD></TR><TR><TD>1</TD><TD>20/11/2012</TD><TD>110</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P></P><P>CJ</P></BODY></HTML> Tue, 27 Nov 2012 11:53:23 GMT https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470438#M175710 2012-11-27T11:53:23Z Re: Getting latest updated value in expression https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470439#M175711 <HTML><HEAD></HEAD><BODY><P>try: </P><P>aggr(FirstSortedValue(Value,-[Change Date],ID)</P></BODY></HTML> Tue, 27 Nov 2012 12:00:21 GMT https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470439#M175711 Gysbert_Wassenaar 2012-11-27T12:00:21Z Re: Getting latest updated value in expression https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470440#M175712 <HTML><HEAD></HEAD><BODY><P>can u post the qvw file for this one</P></BODY></HTML> Tue, 27 Nov 2012 13:10:00 GMT https://community.qlik.com/t5/QlikView/Getting-latest-updated-value-in-expression/m-p/470440#M175712 2012-11-27T13:10:00Z