Discussion Board for collaboration on QlikView Management.
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
Go to Solution.
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
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.
Caption Tab > Special Icons > Send to Excel
Thanks but this only exports a bar or line chart as text I want the actual chart to show
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.
Thanks but this only exports the data I want a bar or line chart to export as a chart
Enable 'copy Image to ClipBoard'
I don’t have the copy to clipboard option in access point. Where in the QMCdo I need to allow this
Ok print and export to excel are enabled for all users in the QMC but not working
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)