topic loading date from excel in QlikView

loading date from excel

Wed, 28 Jan 2015 10:31:15 GMT

Hi Experts,

i have a date field like this(12-Nov-14)from excel. when i am loading this filed in to qlikview.

it is strange sometimes it is loading the Month in upper case like (12-NOV-14) and some times it is in (12-Nov-14)
.. can any one let me know why it is behaving like that

Re: loading date from excel

PrashantSangle — Wed, 28 Jan 2015 10:52:50 GMT

Hi,

It is loading as text.

If possible share your excel file.

Regards

Re: loading date from excel

Anonymous — Wed, 28 Jan 2015 10:56:49 GMT

Using

Date(ExcelField,'DD-MMM-YYYY') should convert and format the data for you

Re: loading date from excel

engishfaque — Wed, 28 Jan 2015 10:59:38 GMT

Dear Sruti,

Use this one,

date(Num#(YourDateFieldName),'DD-MMM-YY')

date(Num(YourDateFieldName),'DD-MMM-YY')

Kind regards,

Ishfaque Ahmed

Re: loading date from excel

sunny_talwar — Wed, 28 Jan 2015 11:03:48 GMT

I would check if the date is actually being picked as a date by QlikView by creating a list box object with the expression =IsText(Date). If you see only -1, that means your date column is actually loaded in as text. If you see both 0's and 1's then some may be loaded as date/num and others as text (wherever it is -1). If it is all showing 0's then I would go into document properties and number tab and pick the date field and assign my own format which would then be consistent across the application.

Best,

Re: loading date from excel

Wed, 28 Jan 2015 11:04:48 GMT

Hi Guys,

It is not about conversion. actually the files are saved with .csv extension..when loading the date field from the

file the the text in the date filed is coming in upper case for some files and lower case for some of the files

Re: loading date from excel

Anonymous — Wed, 28 Jan 2015 11:05:58 GMT

Hi,

Try Formatting date:

Date(Date,'DD-MMM-YYYY') as Date; - will display in text

Date(Date,'DD-MM-YYYY') as Date; will display in numbers.

Reason for loading the Month in mixed case,because date field in excel file itself has mixed case month in date.

Regards

Neetha