Total Not Show on report when we extract data to excel from qliksense

[panipat1990]

Dear Team,

  When i make a report in qliksense. Suppose Product wise sale Total is 600.But when i export to excel then it doesnot show 600 in qliksense.How is it possible in qliksense.

Header 1	Header 2	Header 3	Header 4	Header 5
	600
P1	100
Pr2	200
P3	300

[shraddha_g]

Do you want to show total row in excel or your total is not matching with excel records?

[Gysbert_Wassenaar]

The Export Data option will only export the data used to create the table, not the contents and formatting of the table. Perhaps this extension can do what you want: GitHub - iviasensio/SmartExport: Exporting QS table to Excel with whole look&feel

[panipat1990]

i want to show total sum of sale..like above table 600.. when i make a table in qliksense ..Sum of sale is 600.. But when i export in excel then 600 not showing

[shraddha_g]

there is a option in measure as total option. Select it as Sum instead of Auto.