topic Re: Nprinting 16 - PPT Conditional Slide? in Qlik NPrinting

Nprinting 16 - PPT Conditional Slide?

cbaqir — Mon, 04 Dec 2017 20:41:47 GMT

I have a PPT that has a graph on it. I am looking for a way to say that if the graph doesn't contain any rows to not create the slide. Is that possible?

Re: Nprinting 16 - PPT Conditional Slide?

Lech_Miszkiewicz — Mon, 04 Dec 2017 21:20:16 GMT

Hi - It is not possible out of the box in NPrinitng.

This could be only true if you use a PAGE functionality to loop through a value and create a chart only for existing values (still - one chart will be created anyways)

If you want to completly remove the chart from your PPT - this is not possible in NP.

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Nprinting 16 - PPT Conditional Slide?

hugmarcel — Tue, 23 Jun 2020 20:55:29 GMT

It is not possible in NP, but you could do this (high Level):

1.) Create a QlikView Variable which holds the Information whether the slide should be used or not, depending on the chart data.

2.) Use a dynamic name for the report to be created, use the QV variable to create the name.

3.) In Windows Task Scheduler, set up a background job which evaluates the report file name.

Depending on the file name, the slide shall be deleted from the PPT file, or not. Use a vbs PowerPoint.Application Object to do so in VBS Code:

Option Explicit

Sub DEL()

Dim ppProgram As Object
Dim ppPres As Object
Dim ppSlide As Object
Dim i As Long

On Error Resume Next
Set ppProgram = GetObject(, "PowerPoint.Application")
On Error GoTo 0

    ' set the ppPres object to active PowerPoint presentation
    Set ppPres = ppProgram.ActivePresentation

    ' delete the slide if file Name condition is met, or not:

Set ppSlide = ppPres.Slides(7) 'or any other slide number you want to delete
ppSlide.Delete

End Sub

Marcel