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

1 Solution

Accepted Solutions
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)

View solution in original post

17 Replies
arulsettu
Master III
Master III

can you post sample data that you have and expected output.

kkkumar82
Specialist III
Specialist III

Hi ,

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

ishanbhatt
Creator II
Creator II

Hi Vijayanth,


Select Sorting by Expression:

=Max(date field name)

Select Descending from the dropdown menu.

Hope this helpful to you.

kkkumar82
Specialist III
Specialist III

community2.png

kkkumar82
Specialist III
Specialist III

In  the above pic, See that Date column is first and change order to "Descending"

ishanbhatt
Creator II
Creator II

Yes, you can drag date field on the first position (For sorting).

ishanbhatt
Creator II
Creator II

Select Sort by Expression then write above expression.

After that select Descending.

ishanbhatt
Creator II
Creator II

Right now in the image, you have selected Sort by Numeric option. Instead of this use Sort by Expression and then write

=max(Date field)

Then Select by Descending.

Date Sorting.PNG

You can also use Max(Num(Date Field)) expression.

kkkumar82
Specialist III
Specialist III

I think when dates are coming from Excel files there are already in number format, selecting Descending order might work