topic Re: i want to export qlikview report to powerpoint in QlikView

i want to export qlikview report to powerpoint

udaya_kumar — Mon, 26 Jan 2026 16:26:21 GMT

Hi,

i want to export the qlikview report to powerpoint (ppt or pptx) using OCX.

how to do this, can anyone help me out?

Thanks in advance

Re: i want to export qlikview report to powerpoint

Alexander_Thor — Mon, 05 Dec 2011 09:14:28 GMT

What do you mean by report? A QlikView Defined Report or objects within a qlikview document?

If you want to embed QlikView Objects then go to powerpoint and insert object, you will find the QlikView OCX-Control in the list.

Then set your document and objects in the properties.

If you want to create a Powerpoint presentation from your QlikView Document this sample macro might do the trick for you.

Requires the IE Plugin or Desktop installed.

Sub ppt
'An array with the objects you want to export to powerpoint
Dim myArray(4)
myArray(0) = "CH64"
myArray(1) = "CH04"
myArray(2) = "CH65"
myArray(3) = "CH87"
myArray(4) = "CH68"
'Create ppt object
Set objPPT = CreateObject("PowerPoint.Application")
objPPT.Visible = True
Set objPresentation = objPPT.Presentations.Add
'Apply a template if you want one
objPresentation.ApplyTemplate _
("C:\mytemplate.potx")
'For each object in the array create a new slide and paste it.
For each item in myArray
Set PPSlide = objPresentation.Slides.Add(1,11)
ActiveDocument.GetSheetObject(item).CopyBitmapToClipboard
PPSlide.Shapes.Paste
Next
'Clean up
Set PPSlide = Nothing
Set PPPres = Nothing
Set PPApp = Nothing
End Sub

Re: i want to export qlikview report to powerpoint

udaya_kumar — Mon, 05 Dec 2011 10:18:41 GMT

Hi alexander,

Thanks for valuable reply,

i want to export objects in the document to PPT.

The Client Requirement is to use OCX for Qlikview to export.

But how to use the OCX control in Powerpoint?

Can u help me?

Re: i want to export qlikview report to powerpoint

Wed, 07 Dec 2011 08:00:01 GMT

Hello Uday,

we can always copy image format of qlikview objects in powerpoint.

but i am not sure how to use OCX control in Powerpoint to copy object of Qlikview

thanks

Lavi

Re: i want to export qlikview report to powerpoint

Fri, 06 Jan 2012 16:42:38 GMT

I found your macro quite interesting.

Can you help me with your macro code if (1) I want to export objects from different QV sheets and (2) if I want to put two objects in one slide but at different places.

Jean.

Re: i want to export qlikview report to powerpoint

AlexOmetis — Wed, 19 Dec 2012 15:05:40 GMT

The best way I've found to do this is to use a third party product called NPrinting - it allows you to design, filter & schedule the distribution of reports in PowerPoint format (as well as Excel, Word and HTML). Check it out at www.nprinting.com

Re: i want to export qlikview report to powerpoint

fgolmahi — Wed, 07 Aug 2013 06:00:17 GMT

I'm want make a slide that inside a Qlikview report called.

In this example, both the attached example file should be together otherwise unresponsive

I am waiting for your help

Re: i want to export qlikview report to powerpoint

Wed, 21 Aug 2013 18:01:50 GMT

if you still search a pp macro send me email: wally_masur@safe-mail.net