Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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