topic Re: Automatically reloading data in QlikView

Automatically reloading data

danielnevitt — Tue, 20 Aug 2013 12:01:42 GMT

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

Re: Automatically reloading data

sparur — Tue, 20 Aug 2013 12:04:28 GMT

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.

Re: Automatically reloading data

PhilippeMotillon — Tue, 20 Aug 2013 12:11:27 GMT

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.

Re: Automatically reloading data

danielnevitt — Tue, 20 Aug 2013 12:42:53 GMT

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

Re: Automatically reloading data

sparur — Tue, 20 Aug 2013 12:51:21 GMT

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.

Re: Automatically reloading data

danielnevitt — Tue, 20 Aug 2013 13:52:24 GMT

Hi Anatoly,

Thank you for your reply.

That worked perfectly and it's solved the issue I had.

Regards,

Daniel

Re: Automatically reloading data

danielnevitt — Thu, 29 Aug 2013 11:48:11 GMT

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

Re: Automatically reloading data

sparur — Thu, 29 Aug 2013 12:07:32 GMT

Hi Daniel

What do you mean? Could you please explain more detailed?

thanks.

Re: Automatically reloading data

danielnevitt — Thu, 29 Aug 2013 12:10:55 GMT

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

Re: Automatically reloading data

sparur — Thu, 29 Aug 2013 12:17:48 GMT

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.

Re: Automatically reloading data

danielnevitt — Thu, 29 Aug 2013 14:33:27 GMT

Thanks for your help. This idea does exactly what I required.

Regards,

Daniel

Re: Automatically reloading data

Sun, 03 May 2015 08:25:47 GMT

How can i do this?

I want refresh data automatically

Please help me

Re: Automatically reloading data

Sun, 03 May 2015 08:31:32 GMT

i have a qlikview file that it has a several gauge

and i want refresh my data automatically

But i don't know do it

Please help me

Thanks

Re: Automatically reloading data

Sun, 03 May 2015 08:47:45 GMT

i have a qlikview file that it has a several gauge

and i want refresh my data automatically

But i don't know do it

Please help me

Thanks

Re: Automatically reloading data

vmonitor — Thu, 02 Jul 2015 08:26:41 GMT

Hi,

I created cmd file "C:\Program Files (x86)\QlikView\Qv.exe" /r "\\corp.mao.ru\users\profiles\snaz\My Documents\tmp\codec.qvw", used the Windows Scheduler. It is works, but nothing change in my project. 😞

Re: Automatically reloading data

kailashkotak91 — Tue, 02 Apr 2019 21:55:40 GMT

Daniel,

I am getting an error as 'Failed to open document'

Can you please help ?

Thanks in advance.