topic reload data in QlikView

reload data

amien — Tue, 28 Jul 2009 13:55:26 GMT

is it possible to reload the data every hour automaticly without closing the qlikview and without any reloading messages?

reload data

amars — Tue, 28 Jul 2009 14:24:11 GMT

You can use a batch file to reload the data hourly, by using a command like this

"C:\Program Files\QlikView\QV.exe" /r "C:\QlikView.qvw"

just put the file name instead of QlikView.qvw & put it in a batch file & schedule it. But I don't know how we can run it in background

reload data

amien — Tue, 28 Jul 2009 15:27:27 GMT

Thanks for your reply .. but that is not what i'm looking for

reload data

Tue, 28 Jul 2009 15:57:50 GMT

Hi,

QV 9 has a TSR utility (need to buy seperately) for dynamic refresh. Truely, I am not tested.

Arun

reload data

amien — Tue, 28 Jul 2009 16:14:28 GMT

i think you are refering to this part of the manual, is that correct:

Dynamic Data Update
For the first time in QlikView history it is possible to programmatically
update field data in real-time without running the script. Via new APIs and
more or less standard SQL insert, update and delete commands, any
QlikView field data can be updated directly in RAM. On a server the
updated data is pushed out to the clients.
This functionality is freely available in stand-alone QlikView but requires an
additional license on QlikView Server. See the QlikView API Guide for
more information.

The thing is that i dont have access to a qlikview server. I need to load the data directly out of a MSSQL database

reload data

Wed, 29 Jul 2009 14:39:50 GMT

My comments were based the input from a QV Tech from the team of our dealer. We have QV 8.5 and were desperately looking for the same option for an online data refresh (dynamic refresh) without even interfered by the end user. Probably, version 9 can deliver this, even though currently it is in beta.

-Arun

reload data

Wed, 29 Jul 2009 14:48:23 GMT

Yes this feature is available in the QV9.

reload data

amien — Wed, 29 Jul 2009 15:08:20 GMT

but not without upgrading the server right? plus i'm connected to a sql source .. and dont have a qlikview server

reload data

amien — Wed, 29 Jul 2009 15:09:43 GMT

"C:\Program Files\QlikView\QV.exe" /r "C:\QlikView.qvw" will not work, because the application needs to be always on .. i cant close qlikview

reload data

rwunderlich — Wed, 29 Jul 2009 15:37:36 GMT

If you are using QV Server, you can reload the document and notify the use that refreshed data is available. See "graceful document refresh" in the Ref Guide. There is no need for the Dynamic update feature.

reload data

Wed, 29 Jul 2009 15:52:08 GMT

Rob, this is an offline approach. We indeed look for the online refresh of QV application data. Say, if I am tracking the location of a vehicle on move, it should always show the current. That mean, when a new movement occurs in the transactional system, the QV application data also should be got update automatically by a resident program.

-Arun

reload data

Anonymous — Thu, 30 Jul 2009 11:06:50 GMT

Rob's approach is correct.

Under Document Properties > Server, set the document to "Server performs refresh automatically..." and "Just do it".

When the document is loaded in QVS and a new version of the document is saved to replace the old one, the new document will be loaded into server memory and the new data pushed out to the client.

reload data

amien — Thu, 30 Jul 2009 13:05:12 GMT

this tab sets the document's behavior when run on a Qlikview server ... so the qlikview server pushes the data to the document.. the problem is that my qlikview document is not on a qlikview server and just on a single workstation.

reload data

rwunderlich — Fri, 31 Jul 2009 02:02:07 GMT


Amien wrote:the problem is that my qlikview document is not on a qlikview server and just on a single workstation.

If you can figure out how to trigger a document macro on a timed basis, you can code a macro that uses the API function DoReload. This function does not display a progress window. See the API Guide for details.

The document will not respond to the user when the macro is running.

-Rob

reload data

amien — Fri, 31 Jul 2009 14:55:40 GMT

Thanks Rob .. i see now what you mean..

"document will not respond to the user then macro is running" .... is this also the case why the server push option in 9.0?

reload data

amien — Fri, 31 Jul 2009 16:16:24 GMT

Rob:

"If you are using QV Server, you can reload the document and notify the use that refreshed data is available. See "graceful document refresh" in the Ref Guide. There is no need for the Dynamic update feature."

This option was also availible in 8.5 right?

reload data

rwunderlich — Fri, 07 Aug 2009 01:10:23 GMT


Amien wrote:This option was also availible in 8.5 right?

Yes