Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Hemanth458
Contributor III
Contributor III

OnPostReload does't work in Qlikview Personal Edition

Hi All,

I am sharing step by Step process what I had done.

ctrl+M
Macro code:

Sub ExportToExcel

ActiveDocument.Sheets("SH01").Activate
set obj1 = ActiveDocument.GetSheetObject("CH01")
obj1.ExportBiff "C:\Users\Desktop\Qlik Development\Testing_MacroData.xls"
ActiveDocument.GetApplication.Sleep 1000

End Sub

Then
Ctrl+Alt+D
Selected Trigger->OnPostReload->AddAction->Add->External->Run Macro-> Macro Name : ExportToExcel->Ok

 

Whenever I reload the script manually it doesn't create a file in a specified path.

 

But when I Clik on test it generated a file in a specified path.

 I need whenever the task gets reloaded it generates a file.

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Bill_Britt
Support
Support

Hi,

You need to set this trigger under document properties under triggers tab. Also, OnPostReload only works using the client.

 

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

1 Reply
Bill_Britt
Support
Support

Hi,

You need to set this trigger under document properties under triggers tab. Also, OnPostReload only works using the client.

 

Bill

Bill - Designated Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post