topic Advanced Export to excel across multiple worksheets in QlikView https://community.qlik.com/t5/QlikView/Advanced-Export-to-excel-across-multiple-worksheets/m-p/462127#M488412 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P></P><P>I'm trying to get some advanced functionality out of my excel export.&nbsp; I have a Pivot chart in the attached sample.&nbsp; When I export the data to excel, it will export to one worksheet in excel.&nbsp; I'm trying to get it so that when I export it, the grouped field shows up on it's on worksheet.&nbsp; See the attached excel example.&nbsp; Does anybody know how to do this?&nbsp; further to this, it would be amazing if someone knew how to name the worksheets after each channel.&nbsp; For this example, rather than having each worksheet titled, sheet1, sheet2, sheet3 etc..&nbsp; they would be called CONVENIENCE/GAS, DRUG STORE, LIQUOR STORE etc....</P><P></P><P>thanks!<IMG __jive_id="27603" class="jive-image-thumbnail jive-image" height="468" onclick="" alt="export to excel.jpg" src="/legacyfs/online/27603_export to excel.jpg" width="795" /></P></BODY></HTML> Fri, 21 Dec 2012 22:35:04 GMT 2012-12-21T22:35:04Z Advanced Export to excel across multiple worksheets https://community.qlik.com/t5/QlikView/Advanced-Export-to-excel-across-multiple-worksheets/m-p/462127#M488412 <HTML><HEAD></HEAD><BODY><P>Hi community,</P><P></P><P>I'm trying to get some advanced functionality out of my excel export.&nbsp; I have a Pivot chart in the attached sample.&nbsp; When I export the data to excel, it will export to one worksheet in excel.&nbsp; I'm trying to get it so that when I export it, the grouped field shows up on it's on worksheet.&nbsp; See the attached excel example.&nbsp; Does anybody know how to do this?&nbsp; further to this, it would be amazing if someone knew how to name the worksheets after each channel.&nbsp; For this example, rather than having each worksheet titled, sheet1, sheet2, sheet3 etc..&nbsp; they would be called CONVENIENCE/GAS, DRUG STORE, LIQUOR STORE etc....</P><P></P><P>thanks!<IMG __jive_id="27603" class="jive-image-thumbnail jive-image" height="468" onclick="" alt="export to excel.jpg" src="/legacyfs/online/27603_export to excel.jpg" width="795" /></P></BODY></HTML> Fri, 21 Dec 2012 22:35:04 GMT https://community.qlik.com/t5/QlikView/Advanced-Export-to-excel-across-multiple-worksheets/m-p/462127#M488412 2012-12-21T22:35:04Z Re: Advanced Export to excel across multiple worksheets https://community.qlik.com/t5/QlikView/Advanced-Export-to-excel-across-multiple-worksheets/m-p/462128#M488413 <HTML><HEAD></HEAD><BODY><P>See <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3481">here</A></P></BODY></HTML> Sat, 22 Dec 2012 10:44:20 GMT https://community.qlik.com/t5/QlikView/Advanced-Export-to-excel-across-multiple-worksheets/m-p/462128#M488413 Gysbert_Wassenaar 2012-12-22T10:44:20Z