topic Re: data refreshing in QlikView

data refreshing

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

hi , i am having data coming from oltp , i need data refresh for evry one hour not in admin part , i wanto to write in script level?

Re: data refreshing

muthukumar77 — Fri, 10 Jun 2016 08:35:52 GMT

Hi,

Please confirm, Are you asking about Reload process?

Re: data refreshing

mshailaja — Fri, 10 Jun 2016 08:43:27 GMT

i want to refresh the data by writing code in script level , is there any possibility?

Re: data refreshing

Kushal_Chawda — Fri, 10 Jun 2016 08:44:07 GMT

AFAIK, you cannot do this from script. To initiate the reload process you need to call QV.exe which you can do by manually opening application and hit reload button or you can schedule the job from qlikview server or you can schedule the job from windows task manager by calling the batch script.

Re: data refreshing

Digvijay_Singh — Fri, 10 Jun 2016 08:45:36 GMT

Follow these -

7.1 Command Line Syntax

The QlikView command line invocation can be described by the following syntax (for a description of the

syntax notation used, see Backus-Naur Formalism (page 933)):

[ path ]Qv.exe[ { switch } documentfile ]

The path is the path to the file, either absolute, or relative to the current directory.

documentfile::= [ path ] documentfilename

documentfilename is the name of the document file.

switch is used to mark different options:

Reload switch. The document will be opened and the script reloaded. Thereafter the document will be saved,

and QlikView will close itself.

/rp

The same as above, but with a partial reload.

Load new data. The document will be opened and the script reloaded. The document will not be saved and

QlikView will remain open.

/lp

The same as above, but with a partial reload.

If this switch is immediately followed by a variable name and an assignment, the variable will obtain the

assigned value before the script execution starts.

/nodata

Opens the document without variables, table and field data. This feature is also available for previously

opened documents on The Start Page (page 36).

/NoSecurity

Overrides QlikView security measures against hostile macros and scripts embedded in QlikView documents.

No warning dialogs prompting the user to accept potentially harmful code will be shown. Use this switch

with caution and only with well-known documents.

Example:

qv.exe /r/vMyvar=123 abc.qvw

Note!

In order to avoid error messages to appear when executing scripts in batch mode, always set the script variable

errormode to 0 in the script

Re: data refreshing

oknotsen — Fri, 10 Jun 2016 08:55:02 GMT

No, you can not trigger a reload using script in anyway.

The question however is: What is it that you actually / really want to achieve? What is your actual problem?

Maybe there is a different solution to your problem.

Re: data refreshing

raadwiptec — Fri, 10 Jun 2016 09:01:23 GMT

yes try calling a command execution parameters with in script

C:/........Qv.exe /r test.qvw