Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please differentiate Triggers on the sheet and documents with Samples
Regards,
Sundar
Document Event
Triggers
In this group actions are set to trigger on selected events in the document. An
event has to be selected in the list before it is possible to assign actions or macros
to it.
OnAnySelect
Select this event to assign an action to be executed each time a selection has
been made in any field of the QlikView document.
OnOpen
Select this event to assign an action to be executed each time the QlikView
document is opened. This event will not function when running in the Ajax
Client.
OnPostReduceData
Select this event to assign an action to be executed after each time the Reduce
Data command has been executed.
OnPostReload
Select this event to assign an action to be executed each time the script has
been re-executed.
Add Action(s)
This button opens the Actions (page 532) page. On this page it is possible to
add an action to the trigger. Choose the action macro to assign an existing
macro name or type any name for which a macro can be created later in the
Edit Module (page 875) dialog.
The action will be executed each time the selected document event occurs.
When an action has been assigned to the event, the button changes to Edit
Action and it is possible to change the action for the event.
Field Event Triggers In this group actions are set to trigger on changes in the logical state of a specified
field in the document. Select a field in the list and press one of the buttons
to assign an action to in it. The buttons open the Actions (page 532)
page. Here it is possible to assign an action, including an existing macro
name, or type any name for which a macro can be created later in the Edit
Module (page 875) dialog. For more information about adding actions, see
Actions (page 532).
When an action has been assigned to the field, the button changes to Edit
Action. The following Field Event Triggers exist:
OnSelect
The action will be executed each time a selection has been made in the specified
field.
OnLock
The action will be executed each time the field is locked.
OnChange
The action will be executed each time a selection has been made in any field
which is logically associated with the specified field.
OnUnlock
The action will be executed each time the field is unlocked.
426
Part 5 Sheet and Sheet Objects
Variable Event
Triggers
In this group you can set actions to trigger on changes in the contents of a
specified variable in the document.
Select a variable in the list and press one of the buttons to assign an action to
it. The buttons open the Actions (page 532) page. On this page you can add
an action to the trigger. Choose the action macro to assign an existing macro
name or type any name for which you later can create a macro in the Edit
Module dialog. For more information about adding actions, see Actions (page
532).
When an action has been assigned to the variable, the button changes to Edit
Action and you can change the action for the event. The following Variable
Event Triggers exist:
OnInput
The action will be executed each time a new value is directly entered in the
selected variable.
OnChange
The action will be executed each time the value of the selected variable
changes as a result of changes in other variables or the logical state of the document.
This typically applies when the variable contains a formula.
Any Samples for each
You need create
that, it involves a bit of effort in creating for all. Try it yourself it will help you
If you have got the answers, please mark the correct and helpful answers so that it will the others also ![]()