Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

1 Solution

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

View solution in original post

15 Replies
gauthamchilled
Creator
Creator
Author

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

gauthamchilled
Creator
Creator
Author

Anyone have idea on how to achieve this?

Gautham

oscarmqz
Creator III
Creator III

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
Creator
Creator
Author

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

oscarmqz
Creator III
Creator III

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
Creator
Creator
Author

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

It should export the visible charts even after toggling.

oscarmqz
Creator III
Creator III

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
Creator
Creator
Author

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

oscarmqz
Creator III
Creator III

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