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

[rvijayanth]

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

[ishanbhatt]

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]

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]

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]

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

[rvijayanth]

Sorry I meant dd-mmm-yyyy format

[Anonymous · Accepted solution]

Try to change the date format in the script:

SET DateFormat='DD-MMM-YYYY';

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

[#8]

try

LOAD

     ...

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

     ...

FROM ...

[rvijayanth]

Thanks everyone for the answers. Everyones input helped