topic Re: Excel Export Issue in QlikView

Excel Export Issue

Tue, 24 Mar 2015 09:12:25 GMT

Hi All,

I have written a macro code for export trend table. The table exports successfully but the dates converts to wrong format (mm/dd to mm/dd/yyyy.

For example, when pasted on excel, 11/21 will change to 11/21/2015.

Can we stop this conversion?

Thanks

robert_mika — Tue, 24 Mar 2015 15:20:34 GMT

Try:

Help >> About Qlikview >> right click on the Qlik icon >>

change to String

Mon, 06 Apr 2015 06:47:42 GMT

Hi Robert,

I changed it to String. The export is still showing incorrect dates

Thanks

robert_mika — Mon, 06 Apr 2015 09:21:13 GMT

Could you post your macro?

After the data are being send to Excel you can probably use sendkey function to format the data to desired output.

Mon, 06 Apr 2015 10:26:13 GMT

hi,

when you export data that time date field took the format of your existing system date_time format.

Can you change your system(from where you exporting)date then see.

Regards

Vimlesh