i need a help in exporting qlikview chart objects dynamically using macro to powerpoint ot word.
i have 4 charts in a sheet, 2 will be visible and other 2 will be invisible based on button toggle.
so clicking on a macro button should export only visible charts on the sheet.
only charts and not all objects or entire sheet..
Find the attached qvw. You have to make use of the qlikview variables inside the macro.
You can refer the Qlikview API Automation examples also to implement this. I recently did for my requirement and it helped.
You too can try.
Let me know the attached file is what your requirement.
See the attached document, by default only visible charts are exported, at least that's what happened to me when I tried to export hidden charts, it didn't work, I had to show them using macros too before exporting.
Thanks for the response.
I am attaching a sample app. in the attached app there are 4 charts, 2 hidden. toggle button toggles the two charts.
I want the macro button to export the chart to ppt which are visible. but if the charts are not visible it is not working.
can you help
The attached exports visible charts only, by validating the value of vtoggle variable. What didn't work for me was positioning the picture, left,right,top and bottom throws an error
Do you mean not exporting invisible charts??
Because it does exports only the visible charts in the example I sent you.
In other words, do you want to export the 4 charts despite the toggle status?
If I toggle once it will show chart 1 an chart 2 and if I click the macro button it should export chart1 and chart 2.
If I toggle again it will show chart 3 and chart 4 and if I click the macro button it should export chart 3 and chart 4.
So whichever chart was showing when I click the macro button, it should export.
I don't know how to achive this