Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

rcorcoran
Contributor

exporting chart from access point to excel

Hi

How can I export chart in access point to excel.  I have tried the copy and paste special but it doesn't work.  Really annoying our users

I have the export to excel option but it will not export the chart as a bar or line chart etc only as a table

Any help appreciated

R

1 Solution

Accepted Solutions
rcorcoran
Contributor

Re: exporting chart from access point to excel

I am using access point in full browser and found the solution to this to be:

Right click on chart and select print. this will open chart in a separate window.  Right click and copy.  Paste special into excel as bitmap

13 Replies
Not applicable

Re: exporting chart from access point to excel

You need to insert in the caption of the object the "send to XL file" button. So you just press this button and the table goes to excel.

send to xl.png

awhitfield
Esteemed Contributor

Re: exporting chart from access point to excel

Caption Tab > Special Icons > Send to Excel

Adny

rcorcoran
Contributor

Re: exporting chart from access point to excel

Thanks but this only exports a bar or line chart as text I want the actual chart to show

Rhona

chrislofthouse
Contributor

Re: exporting chart from access point to excel

Renato is correct, however this will export as a table not a visual. You have to select the 'copy to clipboard' option for the image. Also make sure these features are permitted by the QMC.

rcorcoran
Contributor

Re: exporting chart from access point to excel

Thanks but this only exports the data I want a bar or line chart to export as a chart

Rhona

awhitfield
Esteemed Contributor

Re: exporting chart from access point to excel

Enable 'copy Image to ClipBoard'

rcorcoran
Contributor

Re: exporting chart from access point to excel

I don’t have the copy to clipboard option in access point. Where in the QMCdo I need to allow this

Thanks again

rcorcoran
Contributor

Re: exporting chart from access point to excel

Ok print and export to excel are enabled for all users in the QMC but not working

Rhona

awhitfield
Esteemed Contributor

Re: exporting chart from access point to excel

You need to enable it in the actual QVW, PLUS you need be opening the dashboard via IE, using the IE Plugin Option, it's doesn't appear to be available in the Full Browser (AJAK Client)

Andy

Community Browser