Official Support Articles

[Sonja_Bauernfeind]

Totals are not included when exporting data in Qlik Cloud.

Totals and other formatting options can be exported in Qlik Sense Enterprise on Windows. See Downloading data from a table.

This is working as expected. Qlik Cloud only exports the data and the aggregation and will not export formatting/presentation options. See SaaS editions of Qlik Sense/QlikView: data export to Excel does not keep styling (colours, format...... 

[alex_chaourov]

This was correct for 2019...

However, since Nov 2022 Qlik support Data Export from plain table with totals.

See for example: https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/DataExport/export-da...
"In the Data export settings dialog you can select to have enhanced table formatting applied to your export, including styling and row totals"

Question: How to use Qlik API to Data Export from plain table with totals?
Are there any plans to extend current exportData({'format':'EXPORT_OOXML','state':'EXPORT_POSSIBLE', download: true})
...with extra parameter e.g. includeTableFormatting: true ?

[Sonja_Bauernfeind]

Hello @alex_chaourov 

Thank you for reaching out! You are correct about the on-premise/client-managed version of Qlik Sense supporting the export of totals. I have rewritten the article to clarify that the restriction documented here applies to Qlik Cloud, rather than Qlik Sense Enterprise on Windows.

As for your question: 

I have not located an idea around this. I would recommend logging one here.

All the best,
Sonja