Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
amsystem
Partner - Contributor II
Partner - Contributor II

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

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?

Labels (2)
1 Solution

Accepted Solutions
timpoismans
Specialist
Specialist

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.

View solution in original post

4 Replies
timpoismans
Specialist
Specialist

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
Partner - Contributor II
Partner - Contributor II
Author

Ok!

Thanks!

timpoismans
Specialist
Specialist

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

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

Use the "Add totals row" function.

 

shloime_0-1631412548938.png

 

Read more here:

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