topic Re: Trigger Not working on active Sheet in webview in QlikView

Trigger Not working on active Sheet in webview

venkatg6759 — Fri, 18 Oct 2013 13:18:33 GMT

Hello ,

I have a trigger lock all on active sheet which is not working in webview . Can any one tell me what might be the reason. I am using Qlikview 11.2 SR1.

Re: Trigger Not working on active Sheet in webview

Anonymous — Fri, 18 Oct 2013 13:24:02 GMT

Venkata

There are quite few scenarios of triggers simply not working on the AJAX / WebView clients. I expect this is one of those.

Best Regards, Bill

Re: Trigger Not working on active Sheet in webview

venkatg6759 — Fri, 18 Oct 2013 13:27:16 GMT

I tried the same by using macro on active sheet which also doesn't work . Is there any other way to figure out this. I need to lock all the selections on active sheet .

Re: Trigger Not working on active Sheet in webview

Fri, 18 Oct 2013 14:44:34 GMT

Try it (:

In the Qlikview Managment Console -> System->Security -> Check "Allow unsafe macro running in server".

Or attach an example

Regards"

Re: Trigger Not working on active Sheet in webview

Sat, 19 Oct 2013 11:01:59 GMT

Hi Venkata,

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 spec-

ified 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.

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).

This text was taken from the QlikView reference manual V.11

Re: Trigger Not working on active Sheet in webview

sudeepkm — Sat, 19 Oct 2013 13:11:05 GMT

Will it be OK for you to keep a button to navigate to other sheet and in the button action you can set lock all instead of applying it on the sheet. I've seen few cases where Sheet Action triggers do not work as expected so we used buttons to navigate from sheet to sheet and used all the actions required for the sheet in the button.

Re: Trigger Not working on active Sheet in webview

venkatg6759 — Mon, 21 Oct 2013 13:31:45 GMT

I resolved the issue by checking the read only in the sheet properties >security

Thanks all for your valuable suggestions

Re: Trigger Not working on active Sheet in webview

jerrysvensson — Mon, 21 Oct 2013 13:48:20 GMT

OnActivateSheet doesn't work in WebView/full browser mode.

Workaround:

Hide the tabs and use buttons with actions to navigate between tabs instead.

Re: Trigger Not working on active Sheet in webview

lorenwood — Fri, 02 May 2014 13:01:47 GMT

This worked for me!

Re: Trigger Not working on active Sheet in webview

Thu, 22 May 2014 23:14:54 GMT

I have a document that has two "views" associated with it. I have buttons that switch between the views - it really doesn't do much but make some selections behind the scenes. Since the OnOpen doesn't work in Ajax, how can I get the "default" view to come up? I have a variable that keeps track of what view I am in - can that have a default value? How do set it? Thanks for any insight you can provide!

Re: Trigger Not working on active Sheet in webview

Thu, 26 Mar 2015 07:49:22 GMT

Hey,

I know it´s an old question, but maybe this helps another person.

In my case the "on activate sheet triggers" didn´t work eather. I found out that the sheet-triggers can´t handle copy & paste values (in my case...).

I had to put a specific trigger (selection in field trigger) to multiple sheets and copied the field and the value, which was variable in notepad++. On every sheet where I needet the trigger i pasted the field and the variable, but it didn´t work there. Then i found out if you delete the pasted fieldname and write first

=fieldname

and then delete the = it work. It seems thant qlikview doenst recognice a field if you put it in the trigger with copy and paste, IF its an on activate sheet triggers. In other cases it did work well for me.....

Re: Trigger Not working on active Sheet in webview

roysomna — Mon, 11 May 2015 18:36:41 GMT

Thanks Florian for the advice. Did your "On Activate Sheet Triggers" Not work work in AJAX and pluggin veriosn both? For us the triggers work in the pluggin version and does NOT work in AJAX mode. Were are using : Qlik 11.2 SR4

Re: Trigger Not working on active Sheet in webview

Thu, 01 Oct 2015 11:23:57 GMT

Sorry, we only use AJAX in this specific case, so i can´t say anything about the behaviour in the pluggin version.