topic Re: Ignore OnOpen trigger when document is opened with bookmark in QlikView

Ignore OnOpen trigger when document is opened with bookmark

Or — Tue, 25 May 2010 13:22:45 GMT

Dear all,

I'm looking for a way to have QV ignore its OnOpen trigger routine when the document is opened via a bookmark link. Most of our documents have OnOpen triggers that involve Clear All (in case the developer left any selections by accident) and then a selection of a time value (yesterday, current month, etc). Unfortunately, these triggers seem to override any bookmarks that should be activated when the user accesses the document through a link - e.g.

qvp://MyQVServer/MyModel.qvw?bookmark=Server\BM01

Assuming this is intended behavior rather than a bug, is there any way around it?

Specs: QV9 SR2 64 Bit Server 32 Bit clients

TIA,

Ignore OnOpen trigger when document is opened with bookmark

Wed, 09 Nov 2011 15:28:56 GMT

Were you ever able to resolve this?

Re: Ignore OnOpen trigger when document is opened with bookmark

Wed, 09 Nov 2011 16:59:05 GMT

If you are open to use macros the below may work running on document open instead of clearall

set bm = ActiveDocument.GetBookmark("BM01")

if bm.Default = true then

if bm.Bookmark.ApplyLayoutState = false

ActiveDocument.ClearAll false

end if

Kiran.

Ignore OnOpen trigger when document is opened with bookmark

Fri, 11 Nov 2011 02:33:01 GMT

In my scenario, I don't know what the bookmark would be -- each user (restricted) would create a bookmark. Is there a way to determine that any bookmark is attempting to be applied?