Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
subin6600
Creator III
Creator III

Macro to set a trigger - need help

Hello QlikViewer's,

I have a strange request where the trigger on a object should be set with a macro.
The issue is, at times we loose the triggers, so as an exception handling we are wanting to write a macro which will set the trigger as soon as a sheet is activated. How can we achieve this??

Regards,

Subin

3 Replies
marcus_sommer

I think to create or change a trigger with macros won't be possible. But if you used a trigger to execute the macro then the macro could do these things what the triggered action would have be done.

But a trigger couldn't really be lost - are you sure the trigger isn't deleted by a human activity, directly by removing or removing / renaming from the sheet/field/variable or similar?

- Marcus

subin6600
Creator III
Creator III
Author

Hi Marcus,

Its really difficult to reproduce such issues and so don't really have an explanation as to how it had happened. So for handling such incidents in future, I was thinking to create a macro which will check if the triggers are in place and if they are missing, the macro should set the trigger.

I know its kind of being very optimistic but trying to find an answer. Let me know if you could suggest any other solution.

Thanks & Regards,

Subin

marcus_sommer

The easiest way might be to make all your requirements with macro-code. Alternatives could be to upgrade the system to the last release and/or to rebuild the complete application (sometimes a qvw get corrupted - firstly with a more or less copy + paste approach and if it don't work with more efforts for each object).

- Marcus