Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trigger macro

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

7 Replies
Anonymous
Not applicable
Author

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

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Looks reasonable, worth trying for sure

Not applicable
Author

Perfect! Thanks!

Not applicable
Author

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

jerrysvensson
Partner - Specialist II
Partner - Specialist II

I have seen similar problems.

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

Not applicable
Author

It didnt work. Thanks anyway.