Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (2)
1 Solution

Accepted Solutions
Highlighted
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

View solution in original post

4 Replies
Highlighted
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

View solution in original post

Highlighted
Contributor III
Contributor III

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

 

 

Highlighted
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

Highlighted
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
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.