Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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

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