topic Re: Need Help In Qlikview Macro in QlikView

Need Help In Qlikview Macro

tripatirao — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts

I am able to export charts into ppt for selecting each value in listbox but my requirement is i want more than one charts in single slide.

I have attached sample qlikview file along with macro and ppt which i am getting when running the macro.

I have also attached PPT which i want as output.

Please help me. I am trying to get this from past few days but i am not able to get the output.

Regards

Tripati

Re: Need Help In Qlikview Macro

tripatirao — Fri, 03 Mar 2017 12:51:06 GMT

Dear Experts,

Any Help............

Regards

Tripati

Re: Need Help In Qlikview Macro

hector_munoz — Fri, 03 Mar 2017 12:59:46 GMT

Hi Tripati,

Look at this sentences:

powerpoint.ActiveWindow.Selection.ShapeRange.Left = pos_x

powerpoint.ActiveWindow.Selection.ShapeRange.Top = pos_y

With this sentences you can locate last object pasted exactly where you need.

Maybe you also need to resize the objects, smaller, in order they fit to the slide.

I attach you a sample of PPT export (in spanish)...

Long live to macros!!!

Regards,
H

Re: Need Help In Qlikview Macro

tripatirao — Fri, 03 Mar 2017 13:28:50 GMT

Hi,

I have tried with your code

But not getting the desired output,

I have the attached the qlikview file and ppt for your reference.

Regards

Tripati

Re: Need Help In Qlikview Macro

sasiparupudi1 — Fri, 03 Mar 2017 14:05:27 GMT

Please look at the option of using a container.

Macro that combines two sheet objects and export as a single image.

Re: Need Help In Qlikview Macro

tripatirao — Fri, 03 Mar 2017 14:20:28 GMT

Hi Sasidhar,

i have only one chart in my application and Same charts is exporting into ppt by looping through the value of listbox.

If 2 charts are there then I can use your code.

Please check the macro in the attached QV file and suggest me where i have to change the code.

Regards

Tripati

Re: Need Help In Qlikview Macro

hector_munoz — Fri, 03 Mar 2017 14:35:01 GMT

Look at what I attach... I think is what you need... Regards !

Re: Need Help In Qlikview Macro

sasiparupudi1 — Sun, 05 Mar 2017 18:36:48 GMT

Hi Tripati,

Please have a look at my post.. I hope this is what you are expecting. If you are happy with the solution, please do not forget to close the thread by marking a correct and any helpful answers

Loop through a dimension and export a chart into power point

Good Luck

Sas

Re: Need Help In Qlikview Macro

tripatirao — Mon, 06 Mar 2017 12:24:54 GMT

Dear Sasidhar,

Thanks for time on this issue.I have gone through your document.Really nice one.

Really Appreciate your work.

As It was urgent I adopted Hector code and I have implemented on my original application.

It worked fine.