In Qliksense table, how to perform descending sorting of date which is in (dd-mmm-yyyy) format. Ex 01-Jan-2015
Solved! Go to Solution.
Try to change the date format in the script:
(it is case sensitive, M - month, m - minute)
if you are loading data from excel then,
goto the table -> Sort and see that the Date column is in the beginning of the list and make it descending
Select Sorting by Expression:
=Max(date field name)
Select Descending from the dropdown menu.
Hope this helpful to you.
Right now in the image, you have selected Sort by Numeric option. Instead of this use Sort by Expression and then write
Then Select by Descending.
You can also use Max(Num(Date Field)) expression.
I think when dates are coming from Excel files there are already in number format, selecting Descending order might work