Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauthamchilled
Creator
Creator

Dynamic export


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

15 Replies
gauthamchilled
Creator
Creator
Author

No Marques, it just hang when I ran the macro 

Anonymous
Not applicable

Did you change the current local security to "eanble system access" in the vb script module?

sec.JPG

Siva_Sankar
Master II
Master II

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.

Siva_Sankar
Master II
Master II

Attached is for your reference. Check out the examples.

gauthamchilled
Creator
Creator
Author

Thanks Siva, this is wat i wanted. thanks for the help

Anonymous
Not applicable

That is exactly the same as I sent you Gautham..... and you didn't mark mine as correct?