Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rvijayanth
New Contributor III

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

Tags (1)
1 Solution

Accepted Solutions
mov
Esteemed Contributor III

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

Try to change the date format in the script:

SET DateFormat='DD-MMM-YYYY';

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

17 Replies
arulsettu
Honored Contributor III

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

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

kkkumar82
Valued Contributor III

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

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
Contributor II

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

Hi Vijayanth,


Select Sorting by Expression:

=Max(date field name)

Select Descending from the dropdown menu.

Hope this helpful to you.

kkkumar82
Valued Contributor III

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

community2.png

kkkumar82
Valued Contributor III

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

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

ishanbhatt
Contributor II

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

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

ishanbhatt
Contributor II

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

Select Sort by Expression then write above expression.

After that select Descending.

ishanbhatt
Contributor II

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

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
Valued Contributor III

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

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