Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srchilukoori
Specialist
Specialist

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
Specialist
Specialist
Author

Found the Issue.

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

View solution in original post

4 Replies
srchilukoori
Specialist
Specialist
Author

Found the Issue.

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

Not applicable


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
Specialist
Specialist
Author

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
Specialist
Specialist
Author

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

Export data from table/chart from a qlikview app