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: 
ali_hijazi
Partner - Master II
Partner - Master II

Size limitation of the export process

Hello

we are working on Qlik Sense 3.2.2

We have a pivot table (quiet large)

When we try to export it to excel we get the following error message:

You have reached the size limitation of the export process. Please reduce the number of values to export or change the settings.

export.png

is this a limitation to excel or Qlik sense. what settings shall I change as per the message?

please advise

I can walk on water when it freezes
2 Replies
pascal_theurot
Partner - Creator II
Partner - Creator II

Hi Ali,

I'm not aware of a settings that could change the export limitation in 3.2.2 ?

The default maximum number of rows and columns in the Excel export file is:

  • 1048566 rows per sheet. For pivot tables: 1048566 column dimensions. 10 rows can be added after the export.
  • 16384 columns per sheet. If the number of columns exceeds the limit, the exported file is truncated and a warning message is sent.
Pascal
ali_hijazi
Partner - Master II
Partner - Master II
Author

but the message is misleading when mentioning "... or change the settings"

I can walk on water when it freezes