topic OnActivateSheet trigger overwrites selection made via mouse in QlikView https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-overwrites-selection-made-via-mouse/m-p/472591#M176461 <HTML><HEAD></HEAD><BODY><P>The customer's tab is using the Select in Field action on the OnActivateSheet Event Trigger, returning a set of data &gt;=0 for a financial value.</P><P></P><P>The issue is that when they attempt to select a set of data, for example drawing a box around a pie-graph slice, the Trigger re-selects data and overwrites the user selection.</P><P></P><P>For example, they want to see sales from $10 - $20 in the graph, select it and if the Trigger is present it re-selects (not all) data outside of the $10 - $20 range they tried to capture with the mouse selection.</P><P><BR />Is there a way to have the Trigger apply without interferring with selections made by the user?</P><P></P><P></P><P>Thank you.</P></BODY></HTML> Fri, 19 Apr 2013 22:36:00 GMT 2013-04-19T22:36:00Z OnActivateSheet trigger overwrites selection made via mouse https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-overwrites-selection-made-via-mouse/m-p/472591#M176461 <HTML><HEAD></HEAD><BODY><P>The customer's tab is using the Select in Field action on the OnActivateSheet Event Trigger, returning a set of data &gt;=0 for a financial value.</P><P></P><P>The issue is that when they attempt to select a set of data, for example drawing a box around a pie-graph slice, the Trigger re-selects data and overwrites the user selection.</P><P></P><P>For example, they want to see sales from $10 - $20 in the graph, select it and if the Trigger is present it re-selects (not all) data outside of the $10 - $20 range they tried to capture with the mouse selection.</P><P><BR />Is there a way to have the Trigger apply without interferring with selections made by the user?</P><P></P><P></P><P>Thank you.</P></BODY></HTML> Fri, 19 Apr 2013 22:36:00 GMT https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-overwrites-selection-made-via-mouse/m-p/472591#M176461 2013-04-19T22:36:00Z Re: OnActivateSheet trigger overwrites selection made via mouse https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-overwrites-selection-made-via-mouse/m-p/472592#M176462 <HTML><HEAD></HEAD><BODY><P>I have found the Lock All trigger which is also in the OnActivateSheet, is the culprit.&nbsp; Removing it allows a user to make a selection and still filter on data with the other Trigger.</P></BODY></HTML> Fri, 19 Apr 2013 22:47:53 GMT https://community.qlik.com/t5/QlikView/OnActivateSheet-trigger-overwrites-selection-made-via-mouse/m-p/472592#M176462 2013-04-19T22:47:53Z