Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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 .
Try it (:
In the Qlikview Managment Console -> System->Security -> Check "Allow unsafe macro running in server".
Or attach an example
Regards"
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
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
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.
I resolved the issue by checking the read only in the sheet properties >security
Thanks all for your valuable suggestions
OnActivateSheet doesn't work in WebView/full browser mode.
Workaround:
Hide the tabs and use buttons with actions to navigate between tabs instead.
This worked for me!
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!