Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
julian_ortiz
Partner - Contributor III
Partner - Contributor III

Problem with pivot table when export to Excel

Hi,

im working with pivot table and i need to export Excel. While exports to a limited extent, but when you pass a certain number of columns, exports comma separated data. Ej. I have 14 dimensions and 1 Expression and works fine, but when add a dimension, export comma separated data.

Any sugestion?

Thanks

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I think that's because of backward compatibility with older excel versions that can only handle 256 columns. If your pivot table exceeds this number the export format will change to csv.


talk is cheap, supply exceeds demand