Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Hemanth458
New Contributor II

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 (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: OnPostReload does't work in Qlikview Personal Edition

Maybe some of the various settings prevent the execution. Take a look on the security-tab within the document - and the user-properties and also within the script-editor on the setting-tab (not in the menu else in the bottom-left area of the window).

Further you wrote by "manually" reloading - if this mean to manually start a task within the qmc then it couldn't work because on this state no ActiveDocument exists.

- Marcus

4 Replies
MVP & Luminary
MVP & Luminary

Re: OnPostReload does't work in Qlikview Personal Edition

Maybe some of the various settings prevent the execution. Take a look on the security-tab within the document - and the user-properties and also within the script-editor on the setting-tab (not in the menu else in the bottom-left area of the window).

Further you wrote by "manually" reloading - if this mean to manually start a task within the qmc then it couldn't work because on this state no ActiveDocument exists.

- Marcus

Hemanth458
New Contributor II

Re: OnPostReload does't work in Qlikview Personal Edition

Thank you Marcus,

Then if I want to execute the same thing in Qmc than what changes I need to do.

Consider me  new to Qlikview if you have documentation or Script

Share it with me 

Thank you very much in Advance

 

 

MVP & Luminary
MVP & Luminary

Re: OnPostReload does't work in Qlikview Personal Edition

Take a look here: Run-Macro-after-reload-in-QV-Server

- Marcus

Support
Support

Re: OnPostReload does't work in Qlikview Personal Edition

OnPostReload  will not work in the QMC.

 

Bill

Bill - Designated Support Engineer at Qlik
If a post helps to resolve your issue, please mark the appropriate replies as CORRECT.