topic Re: Send to excel option in QlikView

Send to excel option

Wed, 18 Jun 2014 12:23:03 GMT

I'm trying to export a straight table into excel by clicking on "Send to excel" option. While exporting

date field is taken as string in excel. Is there any way to control it and export it as Date field.

Thanks

Re: Send to excel option

alexandros17 — Wed, 18 Jun 2014 12:27:01 GMT

It does if your qlik date format is the same of your excel (windows) date format, otherways it is a string

Hope it helps

Re: Send to excel option

Fri, 20 Jun 2014 09:28:57 GMT

Hi Alessandro,

Thanks for the reply.

The qlikview file that is being developed will be used by different people at different part of the world and each of them will be having their own date format set on their machine. We cannot put restriction on them to set their system format to what we want.

Is there any other way to get date in date format instead of string while exporting to excel using "Send to excel" option ??

Re: Send to excel option

alexandros17 — Fri, 20 Jun 2014 09:32:30 GMT

It's only an idea ...

use 3 fields in the source xls:

Year, Month, Day, in this way all excel files will have the same format and loading these data into qlikview will need only the makedate(year, month, day) function, in this way all dates will have the same format

Re: Send to excel option

Fri, 20 Jun 2014 09:38:29 GMT

Yes, and if you don't want to provoke this format you may build your own after the orginal like

if string looks like 21/06/20014

makedate(left(date,4), mid(date, 4, 2), right(date, 2)

best regards

Chris