topic Re: Order By date not working in QlikView

Order By date not working

Wed, 19 Mar 2014 07:45:17 GMT

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.

Re: Order By date not working

alexandros17 — Wed, 19 Mar 2014 07:51:57 GMT

Try this

LOAD Name,Address,Birthday

Resident Details

Order By Name,Num(Birthday) desc;

Re: Order By date not working

MK_QSL — Wed, 19 Mar 2014 07:56:00 GMT

LOAD Name,Address,Date(Birthday) as Birthday

Resident Details

Order By Name,Date(Birthday) desc;

Re: Order By date not working

MarcoWedel — Wed, 19 Mar 2014 08:39:55 GMT

Hi angellineeee,

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

Re: Order By date not working

jagan — Wed, 19 Mar 2014 08:57:10 GMT

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.

Re: Order By date not working

martinpohl — Wed, 19 Mar 2014 09:09:32 GMT

is it right to order by name, birthday?

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

Regards