Good Morning i am having issues with auto Reloading of my documents
i have the script below as a batch file and i use a schedular to trigger which is working but the problem is the reload is not affecting my Documents in any way, my documents still remain the same way it used to be
the Data doesnt change. i am connected to my live database and when their is changes i need it to reflect on the document in qlikview but nothing is happening until i click the reload button inside the document
That's how QlikView works. The connection to the DB is only kept open while the script executes. The reload button triggers script execution, and at the end of the script, the data model will be update to reflect all data changes. If you now open your document, it will only show you what is stored in the data model, NOT what has been modified in the DB in the meantime. QlikView is not a DB live operator panel.
However, you can look into Direct Discovery which allows for a limited live connection to DB tables.
During your testing, do you keep your document open in QV Desktop, while in the background one or more AutoReloads are performed? In that case you should kniow that the AutoReload will update the document on disk, but will leave the document loaded in memory alone. You'll have to close and reopen the document to view the new rows.
If you want a feature like that (users viewing a document will automatically get a refresh when a reload has been performed in the background) you can switch to QlikView server which will perform a reload in the background and push the new data to all users that are currently viewing the document in their client.
For you info "In QV its not real time data what we see, add a text box with the ReloadTime() ..your data will be according to this time only not the latest one" if you want the lasted you need to schedule it every 15mins or etc so that it reloads often and shows the latest data.