Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Why to give negative sign for HIREDATE in FirstSortedValue function.
Expression: FirstSortedValue(SAL, -HIREDATE)
Thanks in advance.
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.
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.
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.