topic Get the last value from FirstSortedValue function in QlikView https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799217#M1044922 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to get the last order Date for each customer using the FirstSortedValue function</P><P></P><P></P><P>For example</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OrderDate</P><P>miguel&nbsp;&nbsp;&nbsp;&nbsp; 21/01/2014</P><P>Jose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/11/2014</P><P>Carlos&nbsp;&nbsp;&nbsp;&nbsp; 13/01/2014</P><P>Miguel&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2014</P><P></P><P>the output data look like</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp; OrderDate</P><P>Miguel&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2014</P><P>Jose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/11/2014</P><P>Carlos&nbsp;&nbsp;&nbsp;&nbsp; 13/01/2014</P><P></P><P>Anyone can help me?</P></BODY></HTML> Fri, 21 Nov 2014 17:42:29 GMT 2014-11-21T17:42:29Z Get the last value from FirstSortedValue function https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799217#M1044922 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to get the last order Date for each customer using the FirstSortedValue function</P><P></P><P></P><P>For example</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OrderDate</P><P>miguel&nbsp;&nbsp;&nbsp;&nbsp; 21/01/2014</P><P>Jose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/11/2014</P><P>Carlos&nbsp;&nbsp;&nbsp;&nbsp; 13/01/2014</P><P>Miguel&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2014</P><P></P><P>the output data look like</P><P>Name&nbsp;&nbsp;&nbsp;&nbsp; OrderDate</P><P>Miguel&nbsp;&nbsp;&nbsp;&nbsp; 21/11/2014</P><P>Jose&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/11/2014</P><P>Carlos&nbsp;&nbsp;&nbsp;&nbsp; 13/01/2014</P><P></P><P>Anyone can help me?</P></BODY></HTML> Fri, 21 Nov 2014 17:42:29 GMT https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799217#M1044922 2014-11-21T17:42:29Z Re: Get the last value from FirstSortedValue function https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799218#M1044923 <HTML><HEAD></HEAD><BODY><P>This should work in a chart expression:</P><P></P><P>FirstSortedValue( Date#(OrderDate,'DD/MM/YYYY'), Date#(OrderDate,'DD/MM/YYYY'))</P><P></P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/71854_Capture.PNG.png" /></P></BODY></HTML> Fri, 21 Nov 2014 17:56:23 GMT https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799218#M1044923 JonnyPoole 2014-11-21T17:56:23Z Re: Get the last value from FirstSortedValue function https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799219#M1044924 <HTML><HEAD></HEAD><BODY><P>I just solved.</P><P></P><P>Only had to add symbol - to parameters and it works correctly.</P></BODY></HTML> Fri, 21 Nov 2014 20:01:06 GMT https://community.qlik.com/t5/QlikView/Get-the-last-value-from-FirstSortedValue-function/m-p/799219#M1044924 2014-11-21T20:01:06Z