topic Re: Total Not Show on report when we extract data to excel from qliksense in App Development https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221488#M23758 <HTML><HEAD></HEAD><BODY><P>Do you want to show total row in excel or your total is not matching with excel records?</P></BODY></HTML> Thu, 08 Dec 2016 03:52:26 GMT shraddha_g 2016-12-08T03:52:26Z Total Not Show on report when we extract data to excel from qliksense https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221487#M23757 <HTML><HEAD></HEAD><BODY><P>Dear Team,</P><P></P><P>&nbsp; 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.</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 5</STRONG></TH></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;">600</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P1</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">Pr2</TD><TD style="padding: 2px;">200</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">P3</TD><TD style="padding: 2px;">300</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 07 Dec 2016 14:12:09 GMT https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221487#M23757 panipat1990 2016-12-07T14:12:09Z Re: Total Not Show on report when we extract data to excel from qliksense https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221488#M23758 <HTML><HEAD></HEAD><BODY><P>Do you want to show total row in excel or your total is not matching with excel records?</P></BODY></HTML> Thu, 08 Dec 2016 03:52:26 GMT https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221488#M23758 shraddha_g 2016-12-08T03:52:26Z Re: Total Not Show on report when we extract data to excel from qliksense https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221489#M23759 <HTML><HEAD></HEAD><BODY><P>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: <A href="https://github.com/iviasensio/SmartExport" title="https://github.com/iviasensio/SmartExport">GitHub - iviasensio/SmartExport: Exporting QS table to Excel with whole look&amp;feel</A></P></BODY></HTML> Thu, 08 Dec 2016 07:51:00 GMT https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221489#M23759 Gysbert_Wassenaar 2016-12-08T07:51:00Z Re: Total Not Show on report when we extract data to excel from qliksense https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221490#M23760 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Fri, 09 Dec 2016 21:37:25 GMT https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221490#M23760 panipat1990 2016-12-09T21:37:25Z Re: Total Not Show on report when we extract data to excel from qliksense https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221491#M23761 <HTML><HEAD></HEAD><BODY><P>there is a option in measure as total option. Select it as Sum instead of Auto.</P></BODY></HTML> Sat, 10 Dec 2016 06:48:28 GMT https://community.qlik.com/t5/App-Development/Total-Not-Show-on-report-when-we-extract-data-to-excel-from/m-p/1221491#M23761 shraddha_g 2016-12-10T06:48:28Z