topic Re: How to create a batch file in QlikView

How to create a batch file

Mon, 26 Jan 2026 18:19:17 GMT

Can some tell me how to develop a batch file??

I want to create one batch file for reading data from file say 'file.txt' and this 'file.txt' contains user information like username, his/her ID, name of the application he/she has accessed etc.

Regards

Avantika

Re: How to create a batch file

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 10:30:33 GMT

Hi Avantika,

For batch file do you mean a Windows batch file? If so, is it going to be read from QlikView? Or do you mean you want to create a batch file to schedule a task to reload a QlikView file that reads from a third file? In this case, the answer is put this line (modified if any according to your folders) in an empty .BAT file

"C:\Program Files\QlikView10\qv.exe" /r "C:\File.qvw"

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to create a batch file

Tue, 18 Oct 2011 10:53:31 GMT

Hi Miguel

I am not sure about Windows batch file, but yes I want to create a batch file to schedule a task to reload a QlikView file that reads 'file.txt' file.

I have installed 'Grep for Windows', used for file downloading log monitoring. From this I want to read logs & display them in a report. Report will contain details like username, his/her ID, name of the application he/she has accessed etc.

Re: How to create a batch file

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 11:06:36 GMT

Hi,

I'm afraid I'm not getting your requirement right. If you already have QlikView Server, then create the task using the QlikView Enterprise Management Console, going to the Documents tab, clicking on each document you want to reload and setting it up in the right pane, Reload tab.

If you don't have QlikView Server, the line in the post above will do. Then use the Windows Scheduler to perform the reload. But I don't see the relation that Grep for Windows has to all the above. QlikView Server generates several logs you can configure using the QEMC in System, Setup, QlikView Servers, Logging tab and System, Setup, QlikView Web Servers, General. In addition, you can create a log for each file to control the reload process, from within the open document in QlikView Desktop, Settings, Document Properties, Genearl tab, Generate Logfile and usually, Timestamp in logfile name.

Check anyway this QlikView that analyzes the logs above and see if that helps.

But if all the above is wrong or is not what you were looking for, please specify what do you already have built, what do you want, some examples you have seen in the QlikView portal and so.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to create a batch file

Tue, 18 Oct 2011 12:01:15 GMT

Hi Miguel

Sorry for the confusion. I want to create a Window batch file & want to schedule it on daily basis so that everyday I'll get a fresh data.

Regards

Avatnika

Re: How to create a batch file

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 14:10:57 GMT

Hi Avatnika,

Then my first reply is fine. Just put that line, changed as you need, in a .BAT file. Then go to the Windows Scheduler and create a new task that executes this BAT file and you are done.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

How to create a batch file

Thu, 03 Nov 2011 06:46:15 GMT

Hi Miguel

Thnaks for the reply..!!! but what is the procedure for creating a BAT file?

I understood that I need to write following in BAT file :

"C:\Program Files\QlikView10\qv.exe" /r "C:\File.qvw"

Avantika

How to create a batch file

Thu, 03 Nov 2011 07:14:43 GMT

Hi ,

Mentioned above script is procedue for creating batch file.

Regards,

Ravi.

How to create a batch file

Thu, 03 Nov 2011 07:19:46 GMT

Thnaks Ravi, but Could you please explain the process? so that I won't commit any mistake

Regards

Avantika

Re: How to create a batch file

Thu, 03 Nov 2011 07:30:08 GMT

Hi Avantika,

Take a notepad and save it as .bat in that mention below script, But ensure..you have given proper extension of the file or not.

""C:\Program Files\QlikView10\qv.exe" /r "C:\File.qvw""

Process is nothing but the first part willl open the instance of the Qlikview

, /r for reload (other options are /l./v..etc) and third part is qlikview application which is in mentioned path.

Regards,

Ravi.

How to create a batch file

Thu, 03 Nov 2011 13:32:33 GMT

Thnaks Ravi, its helpful..!!

How to create a batch file

pkkushwaha — Thu, 24 Nov 2011 18:04:23 GMT

Hi All,

My problem is similer to above one but small difference.

i want to write a bat who can create new instance. below attached code is .vbs code.

once i run below vbs scriptit tookover existing qv instance.

set Qv = CreateObject("QlikTech.QlikView")
set shell = createobject("wscript.shell")

success = shell.appactivate("Qlikview - [Start Page]")
Set docObj = Qv.OpenDoc("E:\QlikView\test.qvw,3,false)

docObj.Reload
docObj.Save
Set docObj= Nothing
Set Qv= Nothing

My problem is is there any way to open new instance for any reload.

How to create a batch file

pkkushwaha — Thu, 24 Nov 2011 18:05:56 GMT

Hi All,

My problem is similer to above one but small difference.

i want to write a bat who can create new instance. below attached code is .vbs code.

once i run below vbs scriptit tookover existing qv instance.

set Qv = CreateObject("QlikTech.QlikView")
set shell = createobject("wscript.shell")

success = shell.appactivate("Qlikview - [Start Page]")
Set docObj = Qv.OpenDoc("E:\QlikView\test.qvw,3,false)

docObj.Reload
docObj.Save
Set docObj= Nothing
Set Qv= Nothing

My problem is is there any way to open new instance for any reload.

Re: How to create a batch file

rajni_batra — Thu, 21 Jun 2012 06:10:30 GMT

can any one suggst me how to create a batch file.

need to reload application on one server and copy it to another server through a batch file. how can i ???

Re: How to create a batch file

Wed, 29 Jan 2014 06:22:28 GMT

Hi,

can you please screen shot for creating log files in server.

regards

Mahesh T

Re: How to create a batch file

Thu, 17 Jul 2014 05:17:36 GMT

Hi Ravi:

Thank you very much for your post.

Can you explain the other options?

Like what are /l or /v mean? What else do we have for options?

Thank you very much for your help.

Re: How to create a batch file

Anonymous — Tue, 04 Nov 2014 15:55:48 GMT

Hi Angel,

Do you know how to set a parameter needed on the reload in a BATCH file?

Do you know if this is possible? Maybe with /v or /p?

Thanks

Re: How to create a batch file

gandalfgray — Tue, 04 Nov 2014 16:13:00 GMT

The /v switch is for specifying variable values

I don't know a /p switch

/r is the reload switch

I would not use the /l switch in a batch script because that leaves the application open.

An example where the abc.qvw is reloaded with the varoable Myvar set to 123:

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

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.

/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.

Re: How to create a batch file

Anonymous — Tue, 04 Nov 2014 16:26:04 GMT

Thanks i was very helpful.

Now it works!

Re: How to create a batch file

gandalfgray — Tue, 04 Nov 2014 16:30:02 GMT

there should be no space between /v and your variable

/vvApp_Path=0 is correct

/v vApp_Path=0 is not correct

hope this helps