4 Replies Latest reply: Oct 9, 2015 8:46 AM by Avinash R RSS

    Differentiate Triggers on the sheet and documents with Samples

    sundarraj ramchandran

      Hi All,

       

      Please differentiate Triggers on the sheet and documents with Samples

       

      Regards,

      Sundar

        • Re: Differentiate Triggers on the sheet and documents with Samples
          Avinash R

          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.