topic Re: Trigger macro in QlikView

Trigger macro

Thu, 13 Jun 2013 18:17:46 GMT

I am tyring to trigger a macro when changing a cyclic group. Does anyone know how to do that? Appreciate any assistance.

Re: Trigger macro

Anonymous — Thu, 13 Jun 2013 18:27:56 GMT

There is no trigger for that. I suggest using a button instead of cycling group, so the button would cycle through the fields - and trigger a macro.

Regards,
Michael

Re: Trigger macro

Gysbert_Wassenaar — Thu, 13 Jun 2013 18:30:12 GMT

Create a variable as =getcurrentfield([GroupNameHere]) and add the Run Macro action on the OnChange variable trigger.

Re: Trigger macro

Anonymous — Thu, 13 Jun 2013 18:33:25 GMT

Looks reasonable, worth trying for sure

Re: Trigger macro

Thu, 13 Jun 2013 19:48:35 GMT

Perfect! Thanks!

Re: Trigger macro

Thu, 11 Jul 2013 14:49:34 GMT

Hi Gysbert,

This suggestion woked. But I had to create a text box with that variable and hide that text box. I don't know why it needs that text box, but it worked only with that. While testing, I realized that once you clear, and then change the cyclic group, the macro was not getting triggered unless the text box is always set to "show". If I set the view to 'Conditional', it works only the first time you open the application. Please let me know if you have any thoughts as to why this is happening.

Thanks

Re: Trigger macro

jerrysvensson — Fri, 12 Jul 2013 08:44:16 GMT

I have seen similar problems.

Try to put your textbox in a sheet that you then hide. That usually works.

Re: Trigger macro

Fri, 12 Jul 2013 13:49:27 GMT

It didnt work. Thanks anyway.