topic Why to give negative value in FirstSortedValue in QlikView https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815316#M1020823 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Why to give negative sign for <SPAN style="font-size: 13.3333330154419px;">HIREDATE</SPAN> in FirstSortedValue function.</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1427683279242415" jivemacro_uid="_1427683279242415"> <P>Expression: FirstSortedValue(SAL, -HIREDATE)</P> </PRE><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 30 Mar 2015 02:41:31 GMT qlikviewwizard 2015-03-30T02:41:31Z Why to give negative value in FirstSortedValue https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815316#M1020823 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Why to give negative sign for <SPAN style="font-size: 13.3333330154419px;">HIREDATE</SPAN> in FirstSortedValue function.</P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1427683279242415" jivemacro_uid="_1427683279242415"> <P>Expression: FirstSortedValue(SAL, -HIREDATE)</P> </PRE><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 30 Mar 2015 02:41:31 GMT https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815316#M1020823 qlikviewwizard 2015-03-30T02:41:31Z Re: Why to give negative value in FirstSortedValue https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815317#M1020824 <HTML><HEAD></HEAD><BODY><P>The 2nd arguement provides the field to sort. The sort order is always ascending. So if you want to sort in descending order (so that you get the most recent date first) , then just put a negative in front of the 2nd argument. </P><P></P><P>If HireDate is recognized by qlik as a date field it will sort it numerically.</P></BODY></HTML> Mon, 30 Mar 2015 03:16:50 GMT https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815317#M1020824 JonnyPoole 2015-03-30T03:16:50Z Re: Why to give negative value in FirstSortedValue https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815318#M1020825 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Why negative sign in first sorted value is:</P><P></P><P></P><P><STRONG>BY PRECEDING THE SORT VALUE EXPRESSION WITH THE "MINUS SIGN", THE FUNCTION WILL&nbsp; RETURNS THE HIGHEST VALUE.</STRONG></P></BODY></HTML> Mon, 30 Mar 2015 04:09:50 GMT https://community.qlik.com/t5/QlikView/Why-to-give-negative-value-in-FirstSortedValue/m-p/815318#M1020825 2015-03-30T04:09:50Z