Bookmark on Open

[#1]

I have created a bookmark for the  values that I want to set on open of a qlikview document.   If I set that to apply the bookmark on open it only sets one property from the bookmark not both or it does not apply the bookmark at all.  I'm trying to set a current month and current year.  I'm using these formulas to set the current month and year. 

=Year=year(today(1))

=Month=month(today(1))

If I attach that bookmark to a button and use it on the sheet it sets the properties just fine. If I open the document and see that it doesn't apply the bookmark and then hit the button I created to apply the bookmark again it works fine.   I'm not sure what i'm doing wrong here. I'm setting the Document Properties>TRiggers>OnOpen Setting.  I'm using version 10.00.8837.6 sr1

My goal is to make sure on the server version when they open it shows current. 

Much thanks to anyone that can help. 

pat

[IAMDV]

Hi Pat,

I had created the sample document with apply bookmark trigger on "OnOpen" event and this works fine. I am assuming that you are using bookmark id instead of name. However, please can you post the sample QV document to check the issue?

Thanks - DV

[IAMDV · Accepted solution]

Sorry, forgot to attach the document.

Thanks - DV

[#4]

DV

Your subtle comment had great ramifications for me. The bookmark-on-open didn’t work for me since I was using the bookmark name instead of the bookmark id. It now works fine with the bookmark id.

Ur the man!!!!!!!!!!

[IAMDV]

I am glad to know that I was helpful. Do let me know if you need more help.

Cheers - DV