Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor III

Issue in Exporting the excel from the Pivot.

Hello All,

I am facing the issue in exporting the excel from the pivot table.

When Pivot is expanded till 4 dimensions total no. of rows are 12000 and while exporting export is coming in proper excel format.

And when pivot is expanded till 5th dimension the total no. of rows are 29000 and while exporting the export is coming .csv format.

can anyone help why the same application is showing the different functionality for diff records and how can we resolve the issue?

1 Reply

Re: Issue in Exporting the excel from the Pivot.

Check the ini file setting for the max row export to excel:

Export to Excel issue