topic Re: Issue in formatting date field in CSV file. in QlikView

Issue in formatting date field in CSV file.

Wed, 01 Jul 2015 12:08:57 GMT

Hello Community,

I have uploaded below excel (csv) file into Qlik. I am trying to format Column Trim(A) as date but it doesn't work.

I am using Date(A) but below is the result. It removes some values. How can I format as MM/DD/YYYY. I have tried Date(, 'MM/DD/YYYY') but still gives below result. Somehow it is not able to identify that column as date field. Without modifying the csv file (since its a dump from other system) what solution can Qlik offer?

Thanks,

Re: Issue in formatting date field in CSV file.

hic — Wed, 01 Jul 2015 12:14:24 GMT

You have it in DD/MM/YYYY and you want it in MM/DD/YYYY.

Date(Date#( Field, 'DD/MM/YYYY'), 'MM/DD/YYYY')

See QlikView Date fields

HIC

Re: Issue in formatting date field in CSV file.

Gabriel — Wed, 01 Jul 2015 12:18:16 GMT

Hi,

As hic said above, your DATE# function is how the date fields are coming into QlikView and your Date() function outside that is how you want to present the date.

Re: Issue in formatting date field in CSV file.

MayilVahanan — Wed, 01 Jul 2015 12:25:25 GMT

Try like this

LOAD *, Alt(Date(A), date(Date#(A ,'DD/MM/YYYY'),'DD/MM/YYYY')) as A1;

LOAD [PO No.],

FROM

Factory_FORTSrg.xls

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Re: Issue in formatting date field in CSV file.

Wed, 01 Jul 2015 12:31:52 GMT

Thanks Henric it worked!