Differentiate Triggers on the sheet and documents with Samples

Anonymous — Fri, 09 Oct 2015 12:22:23 GMT

Hi All,

Please differentiate Triggers on the sheet and documents with Samples

Regards,

Sundar

Re: Differentiate Triggers on the sheet and documents with Samples

avinashelite — Fri, 09 Oct 2015 12:30:08 GMT

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.

Re: Differentiate Triggers on the sheet and documents with Samples

Anonymous — Fri, 09 Oct 2015 12:32:31 GMT

Any Samples for each

Re: Differentiate Triggers on the sheet and documents with Samples

avinashelite — Fri, 09 Oct 2015 12:40:37 GMT

You need create that, it involves a bit of effort in creating for all. Try it yourself it will help you

Re: Differentiate Triggers on the sheet and documents with Samples

avinashelite — Fri, 09 Oct 2015 12:46:53 GMT

If you have got the answers, please mark the correct and helpful answers so that it will the others also

topic Re: Differentiate Triggers on the sheet and documents with Samples in QlikView

Differentiate Triggers on the sheet and documents with Samples

Re: Differentiate Triggers on the sheet and documents with Samples

Re: Differentiate Triggers on the sheet and documents with Samples

Re: Differentiate Triggers on the sheet and documents with Samples

Re: Differentiate Triggers on the sheet and documents with Samples