QlikView Macro

John_Shep86 — Wed, 23 Nov 2022 16:40:17 GMT

Hello,

I have a macro imbedded in a QlikView dashboard, which I have set a trigger task to run on reload. This works when reloading it manually, but doesn't work when scheduled on QMC. I have also tried running this macro on NPrinting v16, as a run macro task and reload task, but again it runs when I execute manually but doesn't run on the schedule.

The macro is below -

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

sub ExportReport

v = ActiveDocument.Evaluate("=timestamp(today(),'YYYYMMDD')")

ActiveDocument.Variables("vDate").SetContent v, true

set obj = ActiveDocument.GetSheetObject("CH03")
obj.exportex ActiveDocument.Variables("vQVDCommon").GetContent.String &"\PricingProduction_"& ActiveDocument.Variables("vDate").GetContent.String &".qvd",4

end sub

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

I have read that macros don't run on QMC and need a batch file to open the dashboard and reload. This is something I have never done before and wouldn't know where to start. Please can you help to automate this process.

Many thanks,

John

topic QlikView Macro in App Development

QlikView Macro