topic Re: Running MACRO in button click in QlikView

Running MACRO in button click

Mon, 21 Dec 2015 09:22:02 GMT

Hi friends,

I am new to QlikView. I wrote a macro to insert data into SQL server table. When I try to test the macro its working fine without any issue and data is getting inserted.

But when i configure the macro to run from button click I am not able to see any progress.

Below are the steps taken to run the macro:

--> right click on button --> properties --> Action --> Add --> external --> run macro --> Edit module (wrote the VBScript to insert data into SQL server table)

After writing the script clicked test button and data got inserted into Table. But when I tried to click the button there is no change.

Please help to solve the issue.

Thanks

Re: Running MACRO in button click

vikasmahajan — Mon, 21 Dec 2015 09:26:49 GMT

In macro check with the following setting is set

Re: Running MACRO in button click

Mon, 21 Dec 2015 10:06:38 GMT

Thanks Vikas. I tried the option but not working.

Re: Running MACRO in button click

marcus_sommer — Mon, 21 Dec 2015 10:42:20 GMT

Probably the macro-name within the action has a typo then there is no difference within one application and by the same user if a macro is executed within the edit module window or per gui-button.

- Marcus

Re: Running MACRO in button click

Mon, 21 Dec 2015 11:46:23 GMT

Thank you so much Marcus... It worked.