excel export

[#1]

Hi Experts,

Is it possible to get the view of a qlikview pivot table in excel?

My client is asking for it.

i want to do this without using macros.

Please help.

[trdandamudi]

Right click on the Pivot chart and select "Copy To Clipboard" and select "Full Table". Now go to Excel and paste it. You will get the same view as Qlikview, Hope this helps....

[#3]

Hi thirumala,

i want to do this when client export a chart to excel.

The way you suggested will work only on developer application.

[jonathandienst]

No - that can be done by users as well. Or use the Export to Excel option from the caption bar or a right click.

[trdandamudi]

All users can use this option....

[Anonymous]

Yup. 

As long as the User Document has the Print and Export to Excel option is selected for All Users in QMC.

[settu_periasamy]

I don't think it is possible without macro (except Copy to Clipboard -> Full Table)

send to excel formatting in Pivot table‌

if you consider to use macro, refer this thread..

Same Formating of qlikview pivot table in Excel

[#8]

i cant see this option when i view the report on Access point.

Please suggest how to do this on  Accesspoint

[settu_periasamy]

If it is AJAX mode, i think we can't see the Copy to Clipboard option.

[Anonymous]

Use the right click Send to Excel.

I use it regularly via AccessPoint in Ajax mode.