OnPostReload does't work in Qlikview Personal Edition

Hemanth458 — Sat, 16 Nov 2024 03:23:23 GMT

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.

Re: OnPostReload does't work in Qlikview Personal Edition

Bill_Britt — Thu, 06 Jun 2019 13:57:30 GMT

Hi,

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

Bill

topic Re: OnPostReload does't work in Qlikview Personal Edition in QlikView

OnPostReload does't work in Qlikview Personal Edition

Re: OnPostReload does't work in Qlikview Personal Edition