topic Re: I need help executing a reload within Qlikview Application in QlikView

I need help executing a reload within Qlikview Application

Mon, 25 Nov 2013 17:12:05 GMT

Hey everybody,

I am very new to qlikview and have a problem I can't find a solution for (Might be very simple but I'm a novice at best).

I have built a qlikview application with the desktop version and have deployed it to our internal qlikview server.

I have setup a trigger on open to reload. It works fine on my desktop version but not on the server when opened up with the IE Plug-in.

I have tried to setup a button to execute the reload but that doesn't work either although I can execute a macro.

Has anyone experienced this problem before and knows of a solution

Thanks,

Rob

Re: I need help executing a reload within Qlikview Application

stevedark — Fri, 28 Feb 2014 20:31:34 GMT

Most macro functions do not work when called on an OnOpen event on the server. Your best bet is to schedule the reload to happen reasonably frequently on the server. This way fresh data is waiting for the user when they open the document.

How frequently you reload should depend on how long the reload takes and how fluid the data is behind the document.

Hope that helps,

Steve

Re: I need help executing a reload within Qlikview Application

Fri, 28 Feb 2014 20:34:27 GMT

Hi Robert,

Do you have Qlikview Publisher. If so you can set up reload tasks to run on a scheduled basis. Hourly,Daily, Weekly whatever suits your needs.

Thanks

Re: I need help executing a reload within Qlikview Application

stevedark — Fri, 28 Feb 2014 20:36:26 GMT

Hi AJ,

You don't need Publisher to schedule a reload (since about version 8.5) QlikView Server SBE or Enterprise will allow you to do this.

Steve

Re: I need help executing a reload within Qlikview Application

Fri, 28 Feb 2014 20:51:22 GMT

Yup you are right

Re: I need help executing a reload within Qlikview Application

maxgro — Sat, 01 Mar 2014 13:38:34 GMT

you can schedule the reoload in the server:

- open in a browser QMC (qlikview Management Console)

- goto tab Documents

- browse the qlikview doc you want to reload (in the left) and select it

-in the right choose reload tab and

- schedule the reload or reload now (button at the bottom)

you can see the task in status tab, tasks

Re: I need help executing a reload within Qlikview Application

Sat, 01 Mar 2014 14:30:43 GMT

The reload trigger and partial reload trigger do not work in AccessPoint, only in Desktop. If I am wrong and it can be performed please correct me, but I speak from my experience, I've tried several times with different changes and even consulted here in the community but unanswered.

You should try with an alternative, performing reloads at the QMC, or change the logic that you are thinking to solve the business requirements.

Regards.

Re: I need help executing a reload within Qlikview Application

stevedark — Sat, 01 Mar 2014 23:20:32 GMT

You can do a reload from Access Point by triggering an EDX call on the load. If you only have Server you can only have one reload task - so you couldn't have a scheduled one and an EDX one - with Publisher you don't have that limitation.

The EDX task could be started by writing a bit of ASP code on the web server and linking to that URL from inside QlikView. Alternatively an extension could be used to call the URL - there is a very neat one by Stefan Walther which I have not had the chance to use myself yet, but looks like a very good solution:

Reloading QlikView Documents using the Ajax-/Mobile-Client (Triggering EDX Tasks by using a QlikView Extension) (QlikTip…

Cheers,

Steve