Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
js2091
Contributor
Contributor

Problem with formatting exporting from QlikView to Excel?

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

Labels (4)
2 Replies
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
johnca
Specialist
Specialist

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?