Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the Qlikview Desktop version and would like to automatically reload the data files to our projects daily at 9:30am.
The files are created and saved in a folder daily (using the same file name each day).
Any help with how to do this would be much appreciated.
Thanks,
Daniel
Hi Daniel
you should create a command file (open Notepad.exe and save as a new file with CMD file extension, instead of txt) with one command: "C:\Program Files\QlikView\Qv.exe" /r "\\roise\Qlikview\ProjectFiles\test.qvw". Save this file with *.cmd file extension. After that you can schedule this CMD file fith windows task scheduller.
you can use a QMS (QlikView Server) or if you haven't it, you could schedule a windows task. Where you can run a special command file, which will run a Qlikview desktop and reload your qvw.
You need to use the Windows Scheduler to do that.
Qlik Local does not come with an integrated scheduler.
You need to create a script that calls QlikView to reload the data.
the line should be
QLIKVIEWPATH\qv.exe /r abc.qvw
Hope that helps.
Hi Philippe,
Thank you for your reply.
I don't have much experience using Windows Scheduler. Assuming my project is called Test.qvw and is saved in the following location \\rosie\Qlikview\ProjectFiles. How would I select that file and tell the scheduler to reload it?
Thanks,
Daniel
Hi Daniel
you should create a command file (open Notepad.exe and save as a new file with CMD file extension, instead of txt) with one command: "C:\Program Files\QlikView\Qv.exe" /r "\\roise\Qlikview\ProjectFiles\test.qvw". Save this file with *.cmd file extension. After that you can schedule this CMD file fith windows task scheduller.
Hi Anatoly,
Thank you for your reply.
That worked perfectly and it's solved the issue I had.
Regards,
Daniel
Hi Anatoly,
Further to the above code for automatically reloading data, are you able to point me in the right direction to allow me to automate opening a document?
Are there notes available for other similar commands?
Thanks for your help.
Regards,
Daniel
Hi Daniel
What do you mean? Could you please explain more detailed?
thanks.
Hi Anatoly,
Sorry if I wasn't clear.
I would like to open a specific file (name Swaps.qvw) and a specific tab (name Analysis >01/01/2012).
This should then be left open so that when I come login it is open on my screen.
Regards,
Daniel
I'm not sure that I right understand you...
As for open specific tab, you can use special Action, ehich should be assigned with OnOpen trigger.
Open document Properties -> Triggers tab -> OnOpen Even Trigger -> Add Action -> Add -> Layout -> Activate Sheet - OK -> enter your SheetID.