Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

srchilukoori
Valued Contributor

Help with "On PostReload" document trigger

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

Labels (1)
1 Solution

Accepted Solutions
srchilukoori
Valued Contributor

Re: Help with "On PostReload" document trigger

Found the Issue.

The module and file access needs to be checked in the Document Properties> Security

4 Replies
srchilukoori
Valued Contributor

Re: Help with "On PostReload" document trigger

Found the Issue.

The module and file access needs to be checked in the Document Properties> Security

Not applicable

Re: Help with "On PostReload" document trigger


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

srchilukoori
Valued Contributor

Re: Help with "On PostReload" document trigger

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.

srchilukoori
Valued Contributor

Re: Help with "On PostReload" document trigger

Refer to the link below in the resource library for further details.

Export data from table/chart from a qlikview app