Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Pivot Table Download to Excel

Is it stilll the case that you cannot download a qlikview pivot table including the expansions that you have created and these will be carried across into Excel.

4 Replies

Re: Pivot Table Download to Excel


As i understand you want to export the pivot table into excel if so.Yes you are able to export the data of pivot table as excel and yes what ever you created you export it into excel. Please clear your requirements also if i am not clear.

By right click on pivot table and send it to excel.



Not applicable

Re: Pivot Table Download to Excel

Hi Anand,

What I am after is the ability to transfer the expansions as well. At

the moment it if you export it exports what you see and does not give

you the ability once exported to expand and other data. You then have to

create the pivot again in Excel which is time consuming.

Jeff Turnbull

CRM, Systems & Process Manager

Fendercare Marine

T +44 1508 482691 Ext 4045

F +44 1508 482710

M +44 7786 331195


Enterprise House Harveys Lane Seething

Norfolk NR15 1EN United Kingdom

Office Locations

UK | Australia | Middle East | Singapore | Nigeria | Brazil

Re: Pivot Table Download to Excel


As i understand when you want to export the data just right click on the pivot table and click on Expand All and send it to excel. By this you export that data which is in collapse mode. Or i suggest make different pivot table if it is not necesary to put it together.

Hope this helps you.



Esteemed Contributor

Pivot Table Download to Excel

hi its possible to export with expression .

Community Browser