topic Re: excel date load issue in QlikView

excel date load issue

alexpanjhc — Sun, 18 Nov 2012 22:39:16 GMT

I have an excel file with dates in it and I want those dates as my field name

10/2/2012 10/3/2012.....

when i load the file and make them embeded labels, the date becomes 41212, 41213.

How can I solve the problem?

Thank you!

Re: excel date load issue

Anonymous — Mon, 19 Nov 2012 01:33:44 GMT

Use Date() around your fieldname. Example:

Load

date(DateField, 'MM/DD/YYYY') as DateField

From XYZ

Re: excel date load issue

its_anandrjs — Mon, 19 Nov 2012 04:57:30 GMT

Hi,

Make date field to your excel column while loading like

Date(YourDateColumn, 'MM/DD/YYYY') as DateColumn

Regards,

Anand

Re: excel date load issue

Mon, 19 Nov 2012 05:15:15 GMT

in qlikview 2 interpretation functions are there

date#(),timestamp#()---- These functions convert string date format to number date format

date(),timestamp()--- These functions converts number date format to string date format

in ur case use the date()

date(fieldname) as dates

use in ur script

then it converts 41212, 41213 in to 10/2/2012 10/3/2012..

if u need 10/2/2012 10/3/2012.. into 41212, 41213

use the date#(fieldname) as newfield

Re: excel date load issue

alexpanjhc — Mon, 19 Nov 2012 14:56:04 GMT

Sorry i guess I was not clear at all...

My problem is here is the original excel like this for a month

oct-2-2012 oct-3-2012 oct-4-2012 oct-5-2012 oct-8-2012............

email received: 20 30 40 25 32 .....

tickets received: 7 8 9 5 12....

then i need to have a weekly table like this

oct-5-2012 oct-12-2012.....

email received 29 33

tickets received 115 202

I thought I could just sum everything, but then the week is an issue and the hard part for me is that how can I identify what week of the month is that date belongs to? since the dates would be field name.

when i load the dates,they becomes numbers, but i cant load them using date functions because i do not want the actual numbers get changed.

Hope this is a bit clear.

Thanks