Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is the download limit for exporting to excel?

Within Qlik sense a user can view millions of lines of data, but when your user wants to export to excel, how many line items can a user successfully download?  Is there a message displayed to the user when they try to export a sheet that is too big or will the process just fail?

1 Solution

Accepted Solutions
Levi_Turner
Employee
Employee

Yes, there's a message and it'll look like:

ScpFdo4.png

Roughly it's at a million records, but this can vary so do not depend on this. In general, I would highly recommend against exporting massive amounts of data from Qlik Sense. Qlik Sense is built to bring in data and visualize and wasn't designed to be as efficient as possible in getting data outside of it. As an overview, here's a sense of what all occurs when exporting data:

the Engine has to locate the associative [granular] data, construct a HyperCube in RAM on the box with the Engine, calculate visible aggregates, explode the HyperCube in memory and dump it to a temporary file, notify the browser that a temporary file is available, deliver it across the network, and then let the browser write the file to disk (taken from one of our very senior resources here)

View solution in original post

5 Replies
roger_stone
Creator III
Creator III

Levi_Turner
Employee
Employee

Yes, there's a message and it'll look like:

ScpFdo4.png

Roughly it's at a million records, but this can vary so do not depend on this. In general, I would highly recommend against exporting massive amounts of data from Qlik Sense. Qlik Sense is built to bring in data and visualize and wasn't designed to be as efficient as possible in getting data outside of it. As an overview, here's a sense of what all occurs when exporting data:

the Engine has to locate the associative [granular] data, construct a HyperCube in RAM on the box with the Engine, calculate visible aggregates, explode the HyperCube in memory and dump it to a temporary file, notify the browser that a temporary file is available, deliver it across the network, and then let the browser write the file to disk (taken from one of our very senior resources here)

Not applicable
Author

understood... some of our users would like to export smaller chunks to excel so that they can use minitab to conduct their own analysis outside the app.

thanks for your response!

simondachstr
Luminary Alumni
Luminary Alumni

According to this source:

Default limitations in number of cells

The default maximum number of cells in the export file is:

  • 1000000 to export to an Excel file
  • 5000000 to export to a CSV file
shloime
Contributor III
Contributor III

You can use the LogiExport extension to overcome the limitation.

the extension allows exporting a qlik sense objects to CSV files without rows limit, such as many other exciting features.

https://logiexport.logsys.co.il/documentation/ 

 

shloime_0-1630073786733.png