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

[arulsettu]

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

[kkkumar82]

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]

Hi Vijayanth,

Select Sorting by Expression:

=Max(date field name)

Select Descending from the dropdown menu.

Hope this helpful to you.

[kkkumar82]

[kkkumar82]

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

[ishanbhatt]

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

[ishanbhatt]

Select Sort by Expression then write above expression.

After that select Descending.

[ishanbhatt]

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.

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

[kkkumar82]

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