topic How to do an initial selection with Ajax and Qlikview server in QlikView

How to do an initial selection with Ajax and Qlikview server

mellerbeck — Tue, 16 Aug 2011 15:03:48 GMT

It seems like it should be fairly simple but I can't figure out how to do an initial selection using Ajax and the Qlikview Server.

The manaul of course says you can use

Document.OnAnySelect

352

Field.OnSelect

Field.OnChange

Field.OnUnlock

Document.OnPressMacroButton

Variable.OnChange

Variable.OnInput

But not to use

The following triggers are not to be used in the QlikView Server environment, since

they lack meaning or may cause unexpected results:

OnPostReduceData

OnPostReload

The OnOpen Trigger does not appear to work with Ajax (although works fine with the ie client)

Anyone have a solution for this?

How to do an initial selection with Ajax and Qlikview server

mellerbeck — Tue, 16 Aug 2011 20:20:27 GMT

Strange I would think this would be a fairly normal request this was my reply for qliktech support

The OnOpen trigger not working with AJAX is Working As Designed and is due to the way AJAX works with state-status. As for how to have default selections, unfortunately that is outside of the Support Agreement. I would suggest checking our community site (www.qlik.com) or contacting your Account Manager (listed as Andrew Dear, attached) to request help from Expert Services.

How to do an initial selection with Ajax and Qlikview server

mellerbeck — Mon, 22 Aug 2011 21:30:34 GMT

One way of doing is this is using Set Analysis with a variable. So far this has worked for me, but I still wish ajax version had an OnOpen Trigger

How to do an initial selection with Ajax and Qlikview server

rwunderlich — Tue, 23 Aug 2011 04:00:09 GMT

I would push back against the "Working As Designed" for OnOpen not working in Ajax. I don't see anything in the manual for V9 or V10 that limits OnOpen in the server environment. Iif there is a limitation, it should be documented in the manual.

OnOpen with Ajax, action Apply Bookmark, is working fine for me with QV10 SR3.

An alternative to using an OnOpen trigger is to save the document in the state you want it opened. Create a bookmark with search expressions like "=Date=date(today(1))", save those in a bookmark, and remember to apply the bookmark before saving the document in designer.

-Rob

http://robwunderlich.com

How to do an initial selection with Ajax and Qlikview server

disqr_rm — Wed, 22 Feb 2012 22:41:24 GMT

I think if you turn off "Session Recovery" in QMC, the OnOpen trigger will start working in AJAX. Try and please post feeback here.

Re: How to do an initial selection with Ajax and Qlikview server

Fri, 20 Jul 2012 10:36:45 GMT

Hello,

I did as you've suggested but its not working for me.

Could you please suggest something else.

Regards

Re: How to do an initial selection with Ajax and Qlikview server

mellerbeck — Thu, 17 Jan 2013 22:59:01 GMT

Page 426 qlikview 11 ref manual

Document Event

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.

I've been playing with initial selections with AJAX on the iphone. Of course I ran across your own post with the answer

http://qlikviewnotes.blogspot.com/2011/12/initial-selections-and-current.html

Anyways, I was using OnOpen to select in field and then passing a variable. This appeared to work the very first time the qlikview was opened but hitting refresh or opening the qlikview again from the portal would not cause it to use a different value if it was changed.

Looking at your post I created a Search expression pointing to the variable

=gl_perod_id=$(vCurrentPeriod) etc...

this has so far proved very reliable and doesn't use the OnOpen which is supposidly a no no.

I haven't tested OnOpen with a bookmark if that is your normal way I wonder if it side steps what looks like a variable 'caching' ????

Re: How to do an initial selection with Ajax and Qlikview server

rwunderlich — Tue, 22 Jan 2013 07:23:00 GMT

Another option you may want to test is the select parm available when opening in ajax. Assuming gl_period_year is in listbox LB01, add

&select=LB01,2012

-Rob

Re: How to do an initial selection with Ajax and Qlikview server

mellerbeck — Wed, 20 Feb 2013 15:38:21 GMT

Finally ended up using OnOpen with a bookmark with a variable. OnOpen with a bookmark appears to work every time.

Re: How to do an initial selection with Ajax and Qlikview server

Anonymous — Wed, 19 Mar 2014 15:15:25 GMT

looks like it works if you use static value with onOpen trigger - it does not work with dynamic variables.

in my case I needed to set year to the current year so I set my variable in the load script and then used that variable in the onOpen trigger for the document.

Re: How to do an initial selection with Ajax and Qlikview server

Fri, 18 Apr 2014 20:37:35 GMT

I want to second that. In my case I was able to get my OnOpen trigger to work on apps opened in a browser (through QV server) by using a variable set in script and then using the variable without a dollar sign expansion. I'm using QV 11.20 SR5.

Re: How to do an initial selection with Ajax and Qlikview server

bdiamante — Thu, 31 Jul 2014 15:56:48 GMT

Tried this without changing anything else and it worked. Thanks!

Re: How to do an initial selection with Ajax and Qlikview server

evan_kurowski — Thu, 07 Aug 2014 13:09:34 GMT

Rob Wunderlich wrote:

I would push back against the "Working As Designed" for OnOpen not working in Ajax. I don't see anything in the manual for V9 or V10 that limits OnOpen in the server environment. Iif there is a limitation, it should be documented in the manual.

OnOpen with Ajax, action Apply Bookmark, is working fine for me with QV10 SR3.

-Rob

http://robwunderlich.com

Add another to those that experienced an OnOpen trigger working with Ajax (QV 11.2 SR2). We placed a Date = Today() expression in the trigger, cleared selections and saved fresh copies of the document on the server. We reloaded, selected other dates, closed the ajax sessions, to all appearances and testing the trigger appeared to be working, but it was clear the manual said it shouldn't be.