Export to Excel

[AlexGolz]

Hello all,

I wanted to export a table from a dashboard as Excel. Now I run into this error message (see picture).

Before it worked without errors. It should not be because of the rows and columns. (100,000 rows, 20 columns).

Does anyone know what could be wrong?

Best regards

 

 

[PadmaPriya · Accepted solution]

Hello @AlexGolz 

1. This function is controlled by a security rule. Has that been modified on your system?
   Also, some visualization don't export to excel (Pivot Table for example)

Default limitations in number of rows and columns:

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.

You will find more info here :
https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/DataExport/export-data.htm

Thanks,

Padma Priya

Qlik Support

[AlexGolz]

Hello Padma,

thank you for the answer. Maybe I should mention that it ran without problems on a previous version. This error message appears only on the latest patch (Feb 2021 patch 5).

[AlexGolz]

Hello Padma,

thank you for the answer. Maybe I should mention that it ran without problems on a previous version. This error message appears only on the latest patch (Feb 2021 patch 5).