Refresh Document Near Real Time

[#1]

Hi There

One of our requirements is that the QLikView document be refreshed with the most recent data every 30 minutes.

Can this be accomplished with scripting, automating the document to refresh incrementally and only have theat version available. If so how ?

Or would Server / Publisher be required to fulfill this requirement ?

Thanx

[peter_turner]

Hello Sean,

I have a similar application where the data should be reloaded every 10 mins.

As far as i know this process can only be controlled by the QlikView Publisher program.
Publisher allows you to set tasks to be run at a frequency of your choosing, and should be part of the normal server licence.

I've not actually tried this yet but will be in the next few days, If you have a go before then I'd be interested to know how it goes.

Peter.

[#3]

Hi Peter

Thank you for the feedback, i have sent a query to QLikview in this regard to confirm if it is only possible with publisher, will update here once i have feedback.

Thanx

[rwunderlich · Accepted solution]

The reloads are typically done with Publisher, but you can use another scheduling method like Window Scheduler as well.

However, the user must be interacting with Server documents to get notified or updated with fresh data. The feature is called "Graceful Document Refresh" and it is controlled by a two options:

1. QVS (Server) option "Allow only one copy of document in memory" must be checked.
2. In the Document settings, Server tab, are options that control if you want to prompt the user when new data is available or just refresh the user's session.

-Rob

[#5]

Rob -

When you state "interacting with Server documents" does that mean that the user needs to be making a selection of some sort in the application in order for the refresh to occur or does it mean that as long as the application is a server hosted (Publisher controlled) application the data will refresh automatically without the need for the user to make selections (interaction)?

My firm needs to have the application be able to stay open on a desktop and not require that a user periodically make selections in order to have the data refresh - this is a monitoring dashboard.

I've set the Server option "Allow only one copy of document in memory" to checked and selected the "Server performs refresh automatically without client action" as well as setting the Client Interaction Refresh Mode to "Just do it" (even though it is grayed out).

I leave the application open for an hour (4 refresh time periods) and the data never refreshes - it isn't until I click on another tab or control item that the refresh occurs and the proper version of data is displayed.

[#6]

Dear dkern

There is a new licence available with QV9 which allows real time updates on your document without any user interaction (push). But it requires an additionnal licence called real time update server.

If you need that on one particular client, the cheaper is to use a qv analyzer coupled with a real time update file using API ( this one is not necessary to be purchased as a licence)

If you dont use it, the user will need to trigger an event before data are updated.

Rgds,

Sébastien

[#7]

Hi guys,

Do you know if the reload or refresh of data that we can configure using the QV Management Console makes a full reload of the data or just those records that had changes?

Thanks in advance for your help.

[#8]

Hi Sebastien,

Have you got an example of the API needed for real time update? We're in the process of upgrading to V9 at the moment so may end up going down the additional licence route ... depends a bit on how good the capabilities are and the cost of this licence.

Regards,

Emma

[#9]

Rob, does this mean that, if I uncheck the "Allow only one copy of document in memory" then if a user is in a current session during a document reload/refresh, he/she could continue in that session all day without the updated data (using the 'old data'), as long as the current session doesn't expire or isn't closed by the user?

[rwunderlich]

Tyler Waterfall wrote:
Rob, does this mean that, if I uncheck the "Allow only one copy of document in memory" then if a user is in a current session during a document reload/refresh, he/she could continue in that session all day without the updated data (using the 'old data'), as long as the current session doesn't expire or isn't closed by the user?

Yes, but only if the Document Settings, Server, Refresh Mode is not set to "Server performs refresh automatically..."

-Rob