topic Re: Export to excel in QlikView

Export to excel

ali_hijazi — Thu, 17 Oct 2013 08:35:25 GMT

Dear I got a pivot table

one of the dimensions is a date field (date datatype)

in the definition we put: date([Transaction Date],'$(DateFormat)')

Now when we export this table to excel the Transactin date is exported as text

is this a bug?

Re: Export to excel

Thu, 17 Oct 2013 09:12:21 GMT

Check whether you have excel installed on the server.

Re: Export to excel

ali_hijazi — Thu, 17 Oct 2013 09:16:02 GMT

Come on! I said WHEN WE EXPORT IT TO EXCEL i.e. we are getting the excel sheet but the date values are text

Re: Export to excel

sandeepprasad_j — Thu, 17 Oct 2013 09:19:21 GMT

Hello ,

In the properties goto-->Number tab select the date field and check the format settings to date...

hope this helps

Thanks,

Sandeep.

Re: Export to excel

ali_hijazi — Thu, 17 Oct 2013 09:28:27 GMT

it is not a problem of display in QlikView it is a problem of export to excel

IN EXCEL THE DATE COLUMN IS EXPORTED AS TEXT

IN QLIKVIEW EVERYTHING IS FINE

Re: Export to excel

jyothish8807 — Thu, 17 Oct 2013 10:10:35 GMT

Hi,

Try copy full Table option.Then paste it on an excel file.

Still if you face the same issue then go to properties of the pivot table -> Number->Select the particular field which comes in text->select date and give required format.

Thanks & Regards

Jyothish KC

Re: Export to excel

ali_hijazi — Thu, 17 Oct 2013 10:21:14 GMT

the date field is in the dimensions it doesn't appear in the Number tab

I already mentioned that I used date([Transaction Date],'$(DateFormat)')

Re: Export to excel

ali_hijazi — Thu, 17 Oct 2013 10:23:09 GMT

Yes if I copy the whole table and paste it in excel it works fine the field transaction date is exported as date Thank you for your help

but why it doesn't work when Exporting to Excel?!!

Re: Export to excel

jyothish8807 — Thu, 17 Oct 2013 11:34:30 GMT

Try this in the script:

Date(your field,'DD/MM/YYYY') as My date;

Use My date field in the pivot table and try exporting.

Regards

Jyothish KC