Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
fosuzuki
Partner - Specialist III
Partner - Specialist III

Export to Excel - limitation in number of rows

Hi all,

In Sense Desktop, I tried to export 2M rows in one single column, and it truncated to exactly 1M rows. When exporting two columns, it dropped to 500k rows. With three columns, 333.333 rows.


Can someone please confirm if it limits the export to 1M cells?

If so, is there any way to increase this limit?

Does Qlik Sense Server also has this limitation?

Regards,

Fernando

1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III
Author

Thanks Daniel.

I also opened a support case and got a confirmation that the Excel export limitation is to 1M cells, not rows.

My suggestion is to include this information in the documentation and also in the "Finished export" message window. Business users can get confused when exporting as the output is truncated at an apparently random limit.

View solution in original post

10 Replies
Not applicable

The ExcelFormat (xlsx) has some limitations see Excel specifications and limits - Excel

Let us know how you do. Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Regards
Daniel Zanders
QlikSupport
fosuzuki
Partner - Specialist III
Partner - Specialist III
Author

Hi Daniel, thank you for your response.

I'm sorry but I didn't find any useful information in the link you sent. Why didn't Sense export the limit of 1,048,576 in all three cases (with one, two and three columns)?

This is my test script:

load recno() AS Rec,

  'A' AS X,

     'B' AS Y

autogenerate(2000000);

Then, I created a table, added the columns and exported the data.

fosuzuki
Partner - Specialist III
Partner - Specialist III
Author

Bumping up...

Not applicable

Hi Fernando, we will check this with our Product Team to get an answer that explains this.

fosuzuki
Partner - Specialist III
Partner - Specialist III
Author

Hi Daniel Zanders!

Any news on this? Sorry the insistence, but this was reported by a prospect, and I'd like to give him a proper answer.

Not applicable

We got a Feedback and have to say that the Export Function is not designed for bigger amount of data. In this cases it is better to use the store function in the script or the API Functions.

Let us know how you do. Please mark the appropriate replies as helpful / correct so our team and other members know that your question(s) has been answered to your satisfaction.
Regards
Daniel Zanders
QlikSupport
Not applicable

Will this be the Qlik position going forward into the future. That exporting of data will always be limited to some defined limit. This is something we need to be aware of for our consumer/clients of the Qlik platform continuing forward.

fosuzuki
Partner - Specialist III
Partner - Specialist III
Author

Thanks Daniel.

I also opened a support case and got a confirmation that the Excel export limitation is to 1M cells, not rows.

My suggestion is to include this information in the documentation and also in the "Finished export" message window. Business users can get confused when exporting as the output is truncated at an apparently random limit.

scw
Former Employee
Former Employee

This is no longer true. Please refer to the updated documentation in Qlik help. New limit is the limit imposed by excel-


i.e. 1048566 rows per sheet and 16384 columns per sheet.

Exporting data from a visualization ‒ Qlik Sense