Extracting a Qlikview Dashboard in ppt

[#1]

Hi Experts,

Just wnated to check is it possible to extract the dashboards created in Qlikview to ppt's and will that be interactive.

And if it is possible then how we can  do it.

Thanks in advance for the help.

[Sokkorn]

Hi,

Here is my experienced:

1. Take PowerPoint into half right screen

2. Same take QlikView into half left screen

3. Drag QlikView object into PowerPoint

Regards,

Sokkorn

[#3]

Hi,

Just found this macro in community :

Sub Export2PPT_IndividualCharts

Set PPApp = CreateObject("Powerpoint.Application")

PPApp.Visible = True ' Create a presentation

Set PPPres = PPApp.Presentations.Add

Set PPSlide = PPPres.Slides.Add(1, 1)

PPSlide.Shapes(1).Delete ' removes the title

PPSlide.Shapes(1).Delete ' removes the text box

ActiveDocument.GetSheetObject("CH198").CopyBitmapToClipboard

ActiveDocument.GetApplication.WaitForIdle

  with PPSlide.Shapes.Paste

      .Left  = 150

      .Top  = 50

      .Width = 150

      .Height = 450

     end with

PPPres.SaveAs "C:\Individual.ppt" 'comment this if you dont want ppt to close automatically

PPPres.Close          'comment this if you dont want ppt to close automatically

PPApp.Quit      'comment this if you dont want ppt to close automatically

Set PPSlide = Nothing

Set PPPres = Nothing

Set PPApp = Nothing

End Sub

You may have to change the values .Left, .Top, .Width, .Height. I tried the above values then check in ppt and alter the values again. Refer to http://community.qlik.com/message/199532

Not sure as I have not tried this myself.

Hope this helps!

[#4]

Hi Ronny,

  For this you need to have third party tool called N-Printing or you have a work around for this but you can't not create PPT can create PDF using the option of Report.

  First create a report as same a your sheet. This Option is there under reports tab and then call that report in Button call as print report.

Santhosh G

[#5]

Try this solution from Mr. Frank

dynamically save various reports as pdf with different filename