Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Traffic lights not rendered in PDF


I'm facing an issue with the rendering of traffic lights in a PDF file: they are not displayed.

I'm running QV 9 SR4 64bit and I put together the following process:

- windows task scheduler runs below batch file weekly on the server:

"C:\Program Files\QlikView\Qv.exe" /l /NoSecurity "D:\QlikView\src\dev\ppm\qvw\ISE PMO Project Status PDF v_1.0.qvw"

- this QVW has post reload trigger which runs below macro

Sub Create_PMO_PDF


set V=ActiveDocument.Fields("PROJECTNAME").GetPossibleValues
set V2=ActiveDocument.Fields("SENDEMAILCMD").GetPossibleValues

sFile = "D:\QlikView\src\dev\PPM\cmd\PMOSendEmail.bat"

Set oFSO = CreateObject("Scripting.FileSystemObject")

If oFSO.FileExists (sFile) Then oFSO.deletefile (sFile) End If
Set oFile = oFSO.CreateTextFile(sFile)


For i=0 to V.count-1
n = V.Item(i).Text
n2 = V2.Item(i).Text

ActiveDocument.Fields("PROJECTNAME").Select n
ActiveDocument.Fields("SENDEMAILCMD").Select n2

fln= n
fln2= n2

sFile2 = "D:\QlikView\src\dev\PPM\pdf\"& n &".pdf"
Set oFSO2 = CreateObject("Scripting.FileSystemObject")
    If oFSO2.FileExists (sFile2) Then oFSO2.deletefile (sFile2) End If

Set oFile = oFSO.OpenTextFile(sFile,8,true)
oFile.WriteLicreatne n2

Set WSHShell = CreateObject("WScript.Shell")
RegKey = "HKEY_CURRENT_USER\Software\PDFCreator\Program\"
WSHShell.RegWrite RegKey & "UseAutosave", 1
WSHShell.RegWrite RegKey & "AutosaveDirectory","D:\QlikView\src\dev\PPM\pdf\"
WSHShell.RegWrite RegKey & "AutosaveFilename", fln
ActiveDocument.GetApplication.Sleep 30000
Set WSHShell = nothing

set wshShell = CreateObject("Shell.Application")

wshShell.ShellExecute "D:\QlikView\src\dev\PPM\cmd\PMOSendEmail.bat","","","open",1
ActiveDocument.GetApplication.Sleep 15000
end sub

- This macro creates a pdf file per selected dimension value (in this case PROJECTNAME) and afterwards sends it by email to the relevant person.

This process has been running without any issue for 1 year but since today the traffic lights are not rendered anymore in the pdf files while all other charts (bars, lines, bubbles, etc) are correctly displayed.

Additional information: if I manually open the QVW on the server and reload it traffic lights are then correctly rendered in the pdf's. The only difference here with the windows task scheduler way is that QVW runs on the foreground while it runs on the background with the bat file execution.

Any help is welcome.


Community Browser