Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to run a macro, which exports a chart object into the csv format, to be deployed on a QV server 10 SR4. Since the "On PostReload" trigger is not executed when a document is reloaded through publisher, I created a batch file which is executed using the EXECUTE command of QlikView.
I'm using the "/l" to reload the document with GUI, so that the on Post reload works. The reload is successful, but the macro is not triggered after the Reload as intended. I tested the macro with a button and the file is generated as expected, followed by saving the document & quitting the application.
my macro:
Sub ExportToFile
set sObject = ActiveDocument.GetSheetObject("CH149")
sObject.Export "<Docpath>\<DocName>.csv", ","
ActiveDocument.Save
ActiveDocument.closedoc
ActiveDocument.GetApplication.Quit
End Sub
Found the Issue.
The module and file access needs to be checked in the Document Properties> Security
Found the Issue.
The module and file access needs to be checked in the Document Properties> Security
Hi Srchilukoori,
I am trying to export a straight table data into two .csv files on post reload. It works fine on my system,but when I test
it on the qlikview server (QMC) the application reloads but macro is not executed.Could you please suggest how you made
the macro run after post reload.
Thanks in Advance as its an urgent requirement.
Thanks,
Chetan
Chetan,
On Post Reload triggers don't work on the Publisher reloads. You need to run a batch reload to export data, on Post Reload.
Refer to the link below in the resource library for further details.