Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
panipat1990
Not applicable

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

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 1Header 2Header 3Header 4Header 5
600
P1100
Pr2200
P3300
4 Replies
shraddha_g
Not applicable

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

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

Gysbert_Wassenaar
Not applicable

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

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


talk is cheap, supply exceeds demand
panipat1990
Not applicable

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

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
Not applicable

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

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