onopen trigger fails on ajax browser

[#1]

Hi All,

I am developing an app on QV11 SR1.

I have applied document level trigger to select latest fiscal year on "onopen" event.

This trigger works on personal edition but not on browser.

I have ajax client.

Please help me.

thanks in advance

[alexandros17]

I've written to QV support for the same problem and they told me that is a behaviour known and wanted by qlikview, in future releases events will be probably eliminated.

Look for my  the discussion about the argument

[#3]

Hi,

So what should be the alternative?

I tried applying the same trigger on 'onactivate sheet'....but it also creates a problem on browser.

by defualt, when my app opens I should be able to see sheet No. 1.

As the document level trigger does not work, I applied on 'onactivate sheet', but when by defualt the 1st sheet opens, that trigger does not work.

when I go to sheet 2 and come back to sheet 1,then the trigger fires.

Can you please suggest any alternative.

[alexandros17]

The problem discussed with Qlikview Support was about onopensheet event triggered by an event in a button, that is a cascading of events ... triggering an event at document level works even with ajax, try to

trigger onopening the activate sheet action with the id of the sheet

Please let me know

[jerrysvensson]

If you read the manual it states that the OnOpen event doesn't work in Ajax.

But it does work, unsupported of course, in v11 SR2. At least it is working in our environment.

What you need to keep in mind though is that it will only be triggered when you have no session.

To get it to trigger again, you either have to wait for the session to timeout or remove last document state.

OnactivateSheet triggers doesn't work in Ajax. A workaround is to hide the sheets and build your own toolbar at the top and add triggers to text objects or buttons for chainging sheets.

[#6 · Accepted solution]

Thanks Alexandros & Jerry.

I have found the solution. We can use bookmark.

I have created a variable that stores the latest fiscal year value and used it in bookmark.

It's working fine.

[jerrysvensson]

Interesting, we found that variables that changes values did not get their original value back when using bookmarks..

We run SR2 11414 build.

[#8]

Jerry,

SR2 is not that much stable.

Try SR1 ,it is best till now.