topic Re: Find FirstSortedValue, sort by Timestamp in QlikView https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949212#M326651 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>FirstSortedValue({&lt;SettlementTime={'&lt;$(=time(08:00:00:000000))'}&gt;} RunningBalance,-SettlementTime)</P></BODY></HTML> Mon, 28 Sep 2015 12:25:04 GMT pokassov 2015-09-28T12:25:04Z Find FirstSortedValue, sort by Timestamp https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949211#M326650 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>need to find the first sorted value but the below expression does not work for some reason. Something with the timeformat i suppose.&nbsp; </P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">FirstSortedValue</SPAN><SPAN style="font-size: 8pt;">({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SettlementTime</SPAN><SPAN style="font-size: 8pt;">={'&lt;08:00:00:000000'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">RunningBalance</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #800000; font-size: 8pt;">SettlementTime</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Pls find example files attached. </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Regards,</SPAN></P><P><SPAN style="font-size: 8pt;">Olle </SPAN></P></BODY></HTML> Mon, 28 Sep 2015 12:23:26 GMT https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949211#M326650 2015-09-28T12:23:26Z Re: Find FirstSortedValue, sort by Timestamp https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949212#M326651 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>FirstSortedValue({&lt;SettlementTime={'&lt;$(=time(08:00:00:000000))'}&gt;} RunningBalance,-SettlementTime)</P></BODY></HTML> Mon, 28 Sep 2015 12:25:04 GMT https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949212#M326651 pokassov 2015-09-28T12:25:04Z Re: Find FirstSortedValue, sort by Timestamp https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949213#M326652 <HTML><HEAD></HEAD><BODY><P>gr8 thanks!!</P></BODY></HTML> Mon, 28 Sep 2015 12:27:24 GMT https://community.qlik.com/t5/QlikView/Find-FirstSortedValue-sort-by-Timestamp/m-p/949213#M326652 2015-09-28T12:27:24Z