topic Sorting in QlikView

Sorting

Thu, 24 Feb 2011 12:33:14 GMT

Hi ,

I am getting the error as field not found for the below load statement.

LOAD DATE,S.NO,CNAME RESIDENT TABLE1 S.NO ,TIMESTAMP(DATE) ASC;

If i am removing the TIMESTAMP(DATE) then it is working fine.

DATE is STRING so if i am not converting to timestamp then order is not shown properly.

Sorting

Thu, 24 Feb 2011 13:32:05 GMT


XXX wrote:
... LOAD DATE,S.NO,CNAME RESIDENT TABLE1 S.NO ,TIMESTAMP(DATE) ASC;
If i am removing the TIMESTAMP(DATE) then it is working fine.

DATE is STRING so if i am not converting to timestamp then order is not shown properly.
 <div></div>

Do you mean it is sorting by S.NO when you remove the timestamp?

did you miss 'ORDER BY' in the statement above?

-Karthik