topic OnOpen not working correctly in Ajax QV 11 SR1? in QlikView

OnOpen not working correctly in Ajax QV 11 SR1?

hugmarcel — Mon, 26 Jan 2026 18:19:17 GMT

In Ajax client, when a doc is opened, the onopen built-in trigger in document properties menu is set to filter a field by another one as such:

TheWeek = max(FactWeek).

This used to work fine in Ajax Client Version 10, but it does not work in Client Version 11 any more.

Any ideas?

Marcel

OnOpen not working correctly in Ajax QV 11 SR1?

Miguel_Angel_Baeyens — Wed, 25 Apr 2012 13:29:07 GMT

Hi Marcel,

Is that an direct selection by action or a macro? Does it work if you open the file with IE Plugin?

Hope that helps.

Miguel

OnOpen not working correctly in Ajax QV 11 SR1?

hugmarcel — Wed, 25 Apr 2012 13:31:46 GMT

- I do not use macros, so its a direct selection.

- It used to work in QV 10 with the Ajax Client

- It still works with the IEPlugin QV 11!

- The trigger works in Ajax client when I set e.g. TheWeek = 14. So the MAX Function seems to be a problem for the Ajax Client

OnOpen not working correctly in Ajax QV 11 SR1?

Miguel_Angel_Baeyens — Wed, 25 Apr 2012 13:45:41 GMT

Hi,

It's working as designed: OnOpen events will not trigger when using the Ajax client. I have not tested it in version 10, but I'm using version 11 SR1 update (build 11282) and it works as you mentioned. See in the Reference Manual section 30.8 Document Properties: Triggers.

Hope that helps.

Miguel

OnOpen not working correctly in Ajax QV 11 SR1?

hugmarcel — Wed, 25 Apr 2012 14:09:18 GMT

Well, the QV 11 doc does not seem to be fully consistent. As the OnOpen trigger works in Ajax Client when I set a scalar value (14) instead of using a function to a field max(FactWeek).

Any idea how to save this? E.g. it still does not work in Ajax Client when I put the max(FactWeek) into a variable and then set TheWeek = vMaxWeek.

Presetting the field after script reload is not appropriate, as the filtering depends to the windows logged in user.

Thx

OnOpen not working correctly in Ajax QV 11 SR1?

Miguel_Angel_Baeyens — Wed, 25 Apr 2012 14:32:02 GMT

Hi Marcel,

My guess (I'm not in part of the R&D team, they can check this out and give a more accurate answer) is that now QlikView Server uses bookmarks to keep values and layout from users, the so called "Session Recovery", that creates a bookmark, unless disabled in the QMC, for each user that logs into the AccessPoint and stores the state (selections) as well as layout (scrolls, current tab, and so). This bookmarks can be deleted and checked in the Shared objects part of the correspoding document in the Documents or User Documents tab of the QMC.

Bookmarks can store values of variables, so you can try applying a bookmark instead, and the value keep that Max(). Anyway, as I mentioned above, and as you can see in the documentation, some macro functionality is limited in the clients, and specially in the Ajax client, to prevent unexpected results.

If I were you, I'd create a button in the landing page so the user can click on it and "Start" browsing the application. This button sets everything as required, and it all happens on the background.

Hope that helps.

Miguel

OnOpen not working correctly in Ajax QV 11 SR1?

hugmarcel — Wed, 25 Apr 2012 14:52:10 GMT

Hi Miguel

ok thank you for this answer.

I am now setting a Variable in the Script and then reuse this variable in the OnOpen Trigger of the Ajax client. This works.

I will think about your "button based" solution, in order to preset windows-login dependant filter criteria on document startup.

thx a lot - Marcel

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Fri, 20 Jul 2012 10:16:46 GMT

Hello,

I'm having the same problem.

I've created a var vMaxDate in the script but which action should i use in 'On open' ?

Regards

Re: OnOpen not working correctly in Ajax QV 11 SR1?

ivan_will — Fri, 14 Dec 2012 13:54:02 GMT

Hi all, having the same!

Waht a bug That QV, a?

Also using triggers on open sheet - the same problem!

QlikTech - please do something!

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Miguel_Angel_Baeyens — Mon, 17 Dec 2012 09:44:43 GMT

Hi,

What it is not working? Are you using the Ajax client or the IE Plugin? Are you running macros or actions on events? What version of QlikView are you running?

OnOpen events triggered actions (not macros) such as External, Set Variable should work just fine.

Hope that helps.

Miguel

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Mon, 14 Jan 2013 12:43:50 GMT

Hi Miguel,

We have a requirement to access the query string value and refresh the dashboard based on the parameter value.

We reached to a point where in we are able to access the query string and pass the parameter to stored procedures, refresh the dashboard in our local desktop.

When we publish the sheet in the server, the Activate Sheet is not being called and the page remains static all the time.

We even tried to put in On Open Trigger(which sets a variable and reloads the QV document).

We are using Qlikview 11. Please let us know if you can help us in fixing the problem.

Thanks,

Sai

Re: OnOpen not working correctly in Ajax QV 11 SR1?

jerrysvensson — Mon, 14 Jan 2013 14:15:19 GMT

The Active Sheet trigger doesn't work in Ajax.

OnOpen works fine, but it will only run if your session has timed out.

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Bill_Britt — Mon, 14 Jan 2013 15:16:50 GMT

The OnOpen trigger should not work with AJAX. If you look at page 426 of the QlikView Version 11 reference manual you will find:

OnOpen

Select this event to assign an action to be executed each time the QlikView

document is opened. This event will not function when running in the AJAX

Client.

Bill

Re: OnOpen not working correctly in Ajax QV 11 SR1?

jerrysvensson — Mon, 14 Jan 2013 15:26:59 GMT

Yes it says so in the manual but it works fine.

At least in v11 SR2.

Tried in multiple environments.

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Bill_Britt — Mon, 14 Jan 2013 15:32:09 GMT

I have also seen it work at times myself and I am glad you have had luck with the installations. However, it isn't supported and if down the road you have problems, QlikView Support can't help you with it.

Bill

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Tue, 15 Jan 2013 06:42:57 GMT

Hi Britt and Jerry,

Thanks for your responses. Can you please provide us the solution for our situation below:

Is it possible to reload the dashboard when we open the web page where we are loading the dashboard in an IFrame?

Whenever user try to open the Dashboard in Web Page, we need to reload the dashboard as we want to have the updated version of the database(Users may add some data to the database which is not updated in the dashboard until we reload it).

We want a solution wherein we can reload the dashboard before opening the web page.

Please let me know if you need any more details.

Thanks,

Sai

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Bill_Britt — Tue, 15 Jan 2013 13:14:58 GMT

Hi Sai,

I am not a web developer, but I have seen a solution that did this. It was Web base and the user would login to a web page and make selection that was passed to a Database or EXD trigger (not sure how the backend worked). Based on the selections the document was reloaded and the document was open for the users.

Bill

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Tue, 15 Jan 2013 13:49:27 GMT

Hi Bill,

We are looking for the same solution. Can you please provide us with the samples?

We worked on the samples but couldnt find any solution. Can you please provide us a working copy.

The above mentioned points exactly suits our scenario.

Thanks,

Sai Krishna

Re: OnOpen not working correctly in Ajax QV 11 SR1?

Bill_Britt — Sun, 20 Jan 2013 01:50:04 GMT

Hi Sai,

I wish I had the example. However, it was a customers work and I was not able to get it.

Bill

Re: OnOpen not working correctly in Ajax QV 11 SR1?

jafari_ervin — Mon, 29 Jul 2013 08:46:03 GMT

Hi Bill

can you introduce some reference that write specifically which action work in ajax or not?

at least expected from qlikview.