topic Re: Executing Subroutine from Load script in QlikView

Executing Subroutine from Load script

Anonymous — Mon, 02 May 2016 16:02:40 GMT

Hello,

I have a subroutine and several functions, which I have coded in the Edit Module window. The subroutine follows the below format:

SUB exportToExcel_v2

[Code

...

]

END SUB

While I am able to assign this subroutine to a button, and have the subroutine execute when a user clicks on the button, I wondered if there was a way to have the subroutine automatically execute when a user Reloads the LOAD script?

I have been trying to find a solution online and in the reference manual, but I cannot seem to find a concrete answer.

I would really appreciate any assistance with this issue.

Re: Executing Subroutine from Load script

trdandamudi — Mon, 02 May 2016 16:34:21 GMT

May be this:

Go to

Setting-->Document Property-->Trigger-->Select On Post Reload-->Click on Add Button on right side

then add Action as Run Macro --> YourMacroName

Re: Executing Subroutine from Load script

Anonymous — Mon, 02 May 2016 16:41:21 GMT

This was exactly what I was looking for--adding a reload 'Trigger' had not crossed my mind.

Thank you!

Re: Executing Subroutine from Load script

krishnacbe — Mon, 02 May 2016 16:43:49 GMT

Hi,

Please try executing the script below using button event trigger to reload()

LOAD *;
SQL EXEC [SubRoutine Name];

Regards

Krishnapriya