4 Replies Latest reply: Aug 2, 2011 4:39 AM by Jonathan Street RSS

    Dynamic Update and OnOpen Triggers

      Hi

       

      I am having a problem with publishing my QlikView document through Access Point.  We refresh the document every 30 minutes and I have the document set up to "refresh automatically without client action" and have got "Enable Push from Server" and "Enable Dynamic Data Update".

       

      I also have OnOpen Triggers which Activate a specified sheet and then Run a Macro.  This is to ensure that the user is always taken to a particular sheet with specific selections on opening the document.

       

      The problem I have is that everytime the document reloads it seems to be running the OnOpen Triggers and throwing users back to the home page even if they are in the middle of doing something.

       

      Can anybody think of a way to dynamically update data but also have on open triggers?

       

      Hope that all makes sense, any help really appreciated.

       

      Thanks

       

      Jon