topic Re: OnOpen Trigger Work-Around w/Bookmark in QlikView

OnOpen Trigger Work-Around w/Bookmark

jcampbell474 — Fri, 24 Jun 2016 15:39:22 GMT

I need an app to open to the last loaded year and month. Variables created in the load script contain these values. When using OnOpen triggers in the desktop client, it works every time. However, it doesn't work in ajax. I've viewed many threads regarding this and called QV support - who confirmed it. So, I need to create a bookmark to handle the task.

Again, I created two variables in the load script to get the year and month I need. Using the listbox Search and Advanced Search features with these variables, I cannot get the right values selected.

My two variables are: 1) vcFY 2) vmaxFM

vcFY = 2016

vmaxFM = 7

I've entered them as ='$(vcFY)' , =$(vcFY), =vcFY, etc... It simply selects every year. Should variables used in the search be formatted/applied differently?

Thanks!

Re: OnOpen Trigger Work-Around w/Bookmark

swuehl — Fri, 24 Jun 2016 15:57:59 GMT

Try something like

=Year='$(vcFY)'

Re: OnOpen Trigger Work-Around w/Bookmark

jcampbell474 — Fri, 24 Jun 2016 17:07:35 GMT

It works now! Thank you!!

Seems kind of odd that the OnOpen Trigger does not work to select a value in a field, but works to apply a bookmark.

Anyway, again, thank you.

Re: OnOpen Trigger Work-Around w/Bookmark

dzmitry_shmurye — Thu, 10 Nov 2016 12:26:48 GMT

Hi Jason, Is it really works for you?

It doesn,t work for me.

I create 1 var in the load script vCurrMonth = OCTOBER for example.

Then I write search expression for the listbox = Month='$(vCurrMonth)' and the correct vallue selects in the filter.

Then i create bookmark, but when i reload my app and vCurrMonth changes My bookmark apply the old saved value:(

Could you please share me you example if it is possible or help me resolve my problem?

Why bookmark save field value but not the search string?

I did small example is attached.

Thanks in advance!

Re: OnOpen Trigger Work-Around w/Bookmark

jcampbell474 — Thu, 10 Nov 2016 13:26:49 GMT

I added the bookmark to the document OnOpen trigger and tested. It works, but I've found this feature/function to be rather delicate. Reload the document with a different month, then apply the bookmark in the listbox search field (= Month='$(vCurrMonth)') bookmark it and note the bookmark name, enter the bookmark name in Settings > Document Settings > Triggers > Document Event Triggers > OnOpen > Add Action > Bookmark. Save the document and reopen. It should work.

Re: OnOpen Trigger Work-Around w/Bookmark

MariaLopez — Wed, 04 Nov 2020 17:03:59 GMT

Did you solve it? Because I have the same issue.