Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Advanced Export to excel across multiple worksheets

Hi community,

I'm trying to get some advanced functionality out of my excel export.  I have a Pivot chart in the attached sample.  When I export the data to excel, it will export to one worksheet in excel.  I'm trying to get it so that when I export it, the grouped field shows up on it's on worksheet.  See the attached excel example.  Does anybody know how to do this?  further to this, it would be amazing if someone knew how to name the worksheets after each channel.  For this example, rather than having each worksheet titled, sheet1, sheet2, sheet3 etc..  they would be called CONVENIENCE/GAS, DRUG STORE, LIQUOR STORE etc....

thanks!export to excel.jpg

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See here


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

See here


talk is cheap, supply exceeds demand