topic Re: Problem with formatting exporting from QlikView to Excel? in QlikView

Problem with formatting exporting from QlikView to Excel?

js2091 — Sat, 16 Nov 2024 18:45:40 GMT

Hi - Using an IMAC to access QlikView and I've found that when I copy and paste to Excel the columns are not lining up properly. Called my work Helpdesk and we tried 3 different browsers (Safari, Chrome and Firefox) and none of them worked (though they all pasted differently).

He thinks it's the integration between the Mac and Excel (via Office 360) possibly. Anyone got any ideas what I can try?
thanks

Re: Problem with formatting exporting from QlikView to Excel?

Brett_Bleess — Thu, 14 May 2020 20:31:58 GMT

Verify your values are all the same, numeric or alpha-numeric, I suspect you have a mix so some things are right and others are left justified. You would need to use Num() or Text() functions on Qlik side to lock those into those formats. Only thing of which I can think, need further information otherwise to try to help further.

Regards,
Brett

Re: Problem with formatting exporting from QlikView to Excel?

johnca — Thu, 14 May 2020 20:46:09 GMT

What happens when you use the Export or Send to Excel functions? Do they open Excel with proper formatting?

It sounds like you are using the copy table data function, but what about the export functions above?