Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dec 7, 2022 8:50:18 AM
Jun 28, 2019 2:32:42 AM
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......
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 ?
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