Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hugmarcel
Specialist
Specialist

OnOpen not working correctly in Ajax QV 11 SR1?

Hi

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

23 Replies
Not applicable

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

jerrysvensson
Partner - Specialist II
Partner - Specialist II

The Active Sheet trigger doesn't work in Ajax.

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

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
jerrysvensson
Partner - Specialist II
Partner - Specialist II

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

At least in v11 SR2.

Tried in multiple environments.

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable

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

Bill_Britt
Former Employee
Former Employee

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

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable

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

Bill_Britt
Former Employee
Former Employee

Hi Sai,

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

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
jafari_ervin
Creator III
Creator III

Hi Bill

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

at least expected from qlikview.