topic last update value in QlikView https://community.qlik.com/t5/QlikView/last-update-value/m-p/827089#M291202 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a costprice table wit 3 FIELDS</P><P>ITEMID | COSTPRICE | MODIFIEDDATE</P><P></P><P>i need anytime the last costprice per ITEMID</P><P></P><P>can u explain me how i can get these values in an expression? </P></BODY></HTML> Mon, 15 Dec 2014 14:49:21 GMT 2014-12-15T14:49:21Z last update value https://community.qlik.com/t5/QlikView/last-update-value/m-p/827089#M291202 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a costprice table wit 3 FIELDS</P><P>ITEMID | COSTPRICE | MODIFIEDDATE</P><P></P><P>i need anytime the last costprice per ITEMID</P><P></P><P>can u explain me how i can get these values in an expression? </P></BODY></HTML> Mon, 15 Dec 2014 14:49:21 GMT https://community.qlik.com/t5/QlikView/last-update-value/m-p/827089#M291202 2014-12-15T14:49:21Z Re: last update value https://community.qlik.com/t5/QlikView/last-update-value/m-p/827090#M291203 <HTML><HEAD></HEAD><BODY><P>Create a Straight Table</P><P>Dimension</P><P>ITEMID</P><P><BR />Expression</P><P>FirstSortedValue(COSTPRICE,-<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">MODIFIEDDATE)</SPAN></P></BODY></HTML> Mon, 15 Dec 2014 14:50:16 GMT https://community.qlik.com/t5/QlikView/last-update-value/m-p/827090#M291203 MK_QSL 2014-12-15T14:50:16Z