Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
its_anandrjs

Hi,

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.

Regards

Anand

Not applicable
Author

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

www.fendercare.com

Enterprise House Harveys Lane Seething

Norfolk NR15 1EN United Kingdom

Office Locations

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

its_anandrjs

Hi,

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.

Regards,

Anand

SunilChauhan
Champion
Champion

hi its possible to export with expression .

Sunil Chauhan