Macro to set a trigger - need help

[subin6600]

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

[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]

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