topic schedulling scripts in QV in QlikView

schedulling scripts in QV

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to know which is the best way to schedule a script in QV.

I have a doc with a load script that I want to refresh in a daily basis. I can schedule using document properties.

I want to know the best way to do this if I have a doc that is going to be used by several users.

I think that then I should schedule the script in the QV server license isn't it

Other question: how can I pass parameters values to a QV doc, for example parameters with values of path, constants, etc...

I know that I can load a file with parameter - value and create the variables in the doc, but which is the best way?

Any advice will be greatly apreciatted.

Re: schedulling scripts in QV

Gysbert_Wassenaar — Wed, 18 May 2016 18:04:28 GMT

If you have Qlikview Server then you schedule reloads of documents in the QMC (Qlikview Management Console). If you don't have Qlikview Server then you can use Qlikview Desktop and a script that reloads the document and is started by a Windows Scheduled Task. I don't see what passing parameters has to do with it.

Re: schedulling scripts in QV

Anonymous — Wed, 18 May 2016 18:35:00 GMT

Thanks Gysbert,

Can you give me an example of scripts that reloads a document to use in a win scheduled task

Passing parameters is another question not related with schedulling, but I want to solve it

Thanks

Re: schedulling scripts in QV

Gysbert_Wassenaar — Thu, 19 May 2016 05:34:30 GMT

Create a text file and rename it to reload.bat. Put a command like this in it:

"C:\Program Files\Qlikview\qv.exe" /R "D:\My Qlik Documents\My Qlikview File.qvw"

Then schedule that .bat file.

You can pass variables as parameters on the command line with the /v flag:

"C:\Program Files\Qlikview\qv.exe" /R /VvMyVariable=1 "D:\My Qlik Documents\My Qlikview File.qvw"