Why to give negative value in FirstSortedValue

[qlikviewwizard]

Hi All,

Why to give negative sign for HIREDATE in FirstSortedValue function.

Expression: FirstSortedValue(SAL, -HIREDATE)

Thanks in advance.

[JonnyPoole · Accepted solution]

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.

If HireDate is recognized by qlik as a date field it will sort it numerically.

[#3]

Hi,

Why negative sign in first sorted value is:

BY PRECEDING THE SORT VALUE EXPRESSION WITH THE "MINUS SIGN", THE FUNCTION WILL  RETURNS THE HIGHEST VALUE.