Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rvijayanth
Creator
Creator

QlikSense Sorting of date in 01-Jan-2015 format (dd-mmm-yyyy) format

In Qliksense table, how to perform descending sorting of date which is in (dd-mmm-yyyy) format. Ex 01-Jan-2015

17 Replies
ishanbhatt
Creator II
Creator II

Another Simple approach is Drag Date field into the first position in Sorting Pannel.

Select Sorting by Numeric and then select Descending.

If this not working the try above approach what I had already suggested.

rvijayanth
Creator
Creator
Author

These are the things I'm trying but these are not working. The Max(mydate) is not showing any value when I try in a text box. In the load editor I'm using the set format as mm-ddd-yyyy.

What am I doing incorrectly?

Anonymous
Not applicable

From what I see so far, it looks like your Excel data is loaded as text, not as date - load editor sets date format as mm-ddd-yyyy (why ddd?), but you load from excel Excel dd-mmm-yyyy.  Try to make a change in the script when loading your date field:

LOAD

     ...

     date(date#(DateField, 'DD-MMM-YYYY')) as DateField,

     ...

FROM ...

After this your can sort by date ascending or descending.

rvijayanth
Creator
Creator
Author

Thanks. But I also want to display date in dd-mmm-yyyy format.

rvijayanth
Creator
Creator
Author

Sorry I meant dd-mmm-yyyy format

Anonymous
Not applicable

Try to change the date format in the script:

SET DateFormat='DD-MMM-YYYY';

(it is case sensitive, M - month, m - minute)

Not applicable

try

LOAD

     ...

     date(date#(DateField, 'DD-MMM-YYYY'),'DD-MMM-YYYY') as DateField,

     ...

FROM ...

rvijayanth
Creator
Creator
Author

Thanks everyone for the answers. Everyones input helped