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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Exporting into Excel Limitation (column is > 256)

My data : row is > 65,536 and column is > 256.

Is there any limitation defined for downloading data as excel from Straight Table and Pivot Table Objects?

I have to export this..

Suggest from MS Excel or Qlikview End.

Thank u

Labels (4)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Qlikview can only export to the 'old' biff excel format which only supports 64K rows and 256 columns. If you need to export more columns you'll have to export to a csv or text file. You can right click the chart and choose the Export option. You can then choose in which format you want to export the chart.


talk is cheap, supply exceeds demand