Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
hi its possible to export with expression .