Solved: Re: Dynamic export - Qlik Community

gauthamchilled · ‎2015-05-13

hi.

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..

any help

Siva_Sankar · ‎2015-05-14

Gautham,

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.

View solution in original post

gauthamchilled · ‎2015-05-13

how can i export only two visible charts next to next ignoring hidden charts using macro?

gauthamchilled · ‎2015-05-13

Anyone have idea on how to achieve this?

Gautham

Anonymous · ‎2015-05-13

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.

gauthamchilled · ‎2015-05-13

hi,

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

Anonymous · ‎2015-05-13

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

gauthamchilled · ‎2015-05-13

If you toggle and run the macro, it is not exporting the visible chart.

It should export the visible charts even after toggling.

Anonymous · ‎2015-05-13

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?

gauthamchilled · ‎2015-05-13

Hi,

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

Anonymous · ‎2015-05-13

Well that's exactly what the file I attached you is doing, did you tried it?