reload data

[amien]

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

[amars]

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

[amien]

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

[#4]

Hi,

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

Arun

[amien]

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

[#6]

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

[#7]

Yes this feature is available in the QV9.

[amien]

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

[amien]

"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

[rwunderlich]

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.