When exporting table to excel, the total line is not exported

[amsystem]

We have this problem when we try the exporting table to excel, the versión of Qlik Sense is November 2018.

Could you help we?

[timpoismans · Accepted solution]

That is it's intented behaviour.

The export to Excel has never included the total line. When exporting like this, the dimensions and measures are taken into account, not the "options"(total) to the dimension/measure.

You can always use Excel to add the total back in.

[amsystem]

Ok!

Thanks!

[timpoismans]

Pivot tables do allow exporting with total lines, though these kind of tables don't always fit what you want to show.

[shloime]

You can use the LogiExport extension to achieve this functionality and much more.

Use the "Add totals row" function.

Read more here:

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