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: 
Not applicable

Order By date not working

I tried order by date and it's not working is there any other way to sort that column.

Eg.

LOAD Name,Address,Birthday

Resident Details

Order By Name,Birthday desc;

I want the table to load the latest date data first.

Birthday format is in  DD/MM/YYYY

Thank you.

5 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try this

LOAD Name,Address,Birthday

Resident Details

Order By Name,Num(Birthday) desc;

MK_QSL
MVP
MVP

LOAD Name,Address,Date(Birthday) as Birthday

Resident Details

Order By Name,Date(Birthday) desc;

MarcoWedel

Hi

at first please check that your DateFormat is set correctly in your load script.

In our case it should be:

SET DateFormat='DD/MM/YYYY';

Otherwise try:

LOAD Name,Address,Date#(Birthday, 'DD/MM/YYYY') as Birthday

Resident Details

Order By Name,Date#(Birthday, 'DD/MM/YYYY') desc;

regards

Marco

jagan
Luminary Alumni
Luminary Alumni

Hi,

I think you need to format the date like this before ordering, currently your date field is considering as string.

Eg.

LOAD Name,

Address,

Date(Date#(Birthday, 'DD/MM/YYYY')) AS Birthday

Resident Details

Order By Name, Date#(Birthday, 'DD/MM/YYYY') desc;

Regards,

Jagan.

martinpohl
Partner - Master
Partner - Master

is it right to order by name, birthday?

This means each name has different birthday which need to be ordered.

Regards