topic Re: Export to Excel Issues in QlikView

Export to Excel Issues

vijayit43 — Fri, 06 Nov 2015 12:08:07 GMT

Hi All,

When We Export to excel from Qlik View then date Column data shows as a Special Character. for Reference Screen Shot attached. this type problem occurred when export huge data. please suggest how to solve this.

Re: Export to Excel Issues

Anonymous — Fri, 06 Nov 2015 12:17:34 GMT

IS it for every date record??

Re: Export to Excel Issues

vijayit43 — Fri, 06 Nov 2015 12:23:18 GMT

Yes every date record show.

Re: Export to Excel Issues

Anonymous — Fri, 06 Nov 2015 12:26:56 GMT

may be some format issue..

Recheck your farmat of date which should be common...

Are you getting same in QV or its only in Excel?

Re: Export to Excel Issues

vijayit43 — Fri, 06 Nov 2015 12:30:08 GMT

Only in Excel when we select multiple days record then problem occurred but when we select only one date then every thing is fine.

Re: Export to Excel Issues

Anonymous — Fri, 06 Nov 2015 12:34:56 GMT

You can check following threads, Try to export it once more:

Export To Excel

Export Qlikview objects to multiple Excel sheet

Else, pls post sample data

Re: Export to Excel Issues

settu_periasamy — Fri, 06 Nov 2015 12:54:54 GMT

Hi,

Check the below link..

Funny characters appearing when exporting from Qlikview to Excel