Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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

Re: Advanced Export to excel across multiple worksheets

See here


talk is cheap, supply exceeds demand
1 Reply

Re: Advanced Export to excel across multiple worksheets

See here


talk is cheap, supply exceeds demand
Community Browser