topic Pivot Table Download to Excel in QlikView

Pivot Table Download to Excel

Wed, 24 Aug 2011 07:40:33 GMT

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.

Re: Pivot Table Download to Excel

its_anandrjs — Wed, 24 Aug 2011 07:44:51 GMT

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

Re: Pivot Table Download to Excel

Wed, 24 Aug 2011 08:09:59 GMT

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

Re: Pivot Table Download to Excel

its_anandrjs — Wed, 24 Aug 2011 08:22:22 GMT

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

Pivot Table Download to Excel

SunilChauhan — Wed, 24 Aug 2011 08:39:26 GMT

hi its possible to export with expression .