topic Re: Dynamic export in QlikView

Dynamic export

gauthamchilled — Wed, 13 May 2015 09:53:55 GMT

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

Re: Dynamic export

gauthamchilled — Wed, 13 May 2015 10:28:49 GMT

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

Re: Dynamic export

gauthamchilled — Wed, 13 May 2015 13:48:39 GMT

Anyone have idea on how to achieve this?

Gautham

Re: Dynamic export

Anonymous — Wed, 13 May 2015 13:52:43 GMT

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.

Re: Dynamic export

gauthamchilled — Wed, 13 May 2015 14:28:12 GMT

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

Re: Dynamic export

Anonymous — Wed, 13 May 2015 14:44:42 GMT

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

Re: Dynamic export

gauthamchilled — Wed, 13 May 2015 14:50:36 GMT

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

It should export the visible charts even after toggling.

Re: Dynamic export

Anonymous — Wed, 13 May 2015 14:54:40 GMT

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?

Re: Dynamic export

gauthamchilled — Wed, 13 May 2015 14:59:18 GMT

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

Re: Dynamic export

Anonymous — Wed, 13 May 2015 15:17:50 GMT

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

Re: Dynamic export

gauthamchilled — Wed, 13 May 2015 15:44:36 GMT

No Marques, it just hang when I ran the macro

Re: Dynamic export

Anonymous — Wed, 13 May 2015 15:54:22 GMT

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

Re: Dynamic export

Siva_Sankar — Thu, 14 May 2015 07:52:43 GMT

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.

Re: Dynamic export

Siva_Sankar — Thu, 14 May 2015 07:59:26 GMT

Attached is for your reference. Check out the examples.

Re: Dynamic export

gauthamchilled — Thu, 14 May 2015 08:02:56 GMT

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

Re: Dynamic export

Anonymous — Thu, 14 May 2015 13:39:40 GMT

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