Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Currently I am using OLEDB connection to load data from sql and then using STORE to save data into a QVD file. Is there a way to update qvd file automatically as the sql database get updated weekly without physically opening dashboard and reloading?
Thanks for the help.
Regards,
Mohammad.
You need a separated qvw that would be reloaded several times during the day
Hi Anjos,
I actually get the data refresh just once a week and just want the dashboard to update without physically going in and reloading.
I haven’t done this before, is it possible for you to define the whole process or through an example (that would be great).
Many Thanks,
Mohammad.
You split the process into 2 qvw.
This tutorial covers that part http://global.qlik.com/~/media/Files/training/tutorials-qv11/English.ashx
Hi Mohammad!
Normally the companies use Qlikview Server to schedule the QVW reload. If you want to schedule the reload only using the Desktop version of QV, you can use a schedule program. In Windows (it's just what I know), there is the "Scheduled Tasks" program that can execute commands from a batch file in a period of time. In this case, the bat file (a text file with .bat extension) should have a command line something like this:
c:\Program Files\Qlikview\qv.exe /r YourQVApp.qvw
Hope this helps!
Marcello