topic Re: How to run/execute qlikview minimized in QlikView

How to run/execute qlikview minimized

Anonymous — Sat, 12 Jul 2014 19:51:37 GMT

My question is simple.

I have qlikview scheduled to open, run and close automatically.

But sometimes it opens and runs maximized. I want it to run minimized or in silent mode. Is there a way?

Thanks.

Re: How to run/execute qlikview minimized

aveeeeeee7en — Sat, 12 Jul 2014 20:01:47 GMT

Hi Goncalo

Use Qlikview Management Console (QMS) for it.

Do reload with QMS. It will not open any window. In case of any error it will send you the Mail, the Mail Id which you have provided.

Regards

Aviral Nag

Re: How to run/execute qlikview minimized

Anonymous — Sat, 12 Jul 2014 20:07:44 GMT

Hi Aviral,

I am not using Qlikview server on this. I'm using v11 desktop client.

Re: How to run/execute qlikview minimized

fkeuroglian — Sat, 12 Jul 2014 21:35:24 GMT

Gonzalo

Could you schedule in the qlikview console managment?

it is easier to do if you set schedule in the qmc , reload automatic and dont open the desktop

can you use the qmc or you have to do in the desktop ?

Re: How to run/execute qlikview minimized

Anonymous — Sun, 13 Jul 2014 11:05:31 GMT

Isn't qlikview console management only available on the server edition? I don't have a license for that, unfortunately.

Re: How to run/execute qlikview minimized

aveeeeeee7en — Tue, 29 Jul 2014 12:06:45 GMT

If Server is not there than you can use ErrorMode() function in your script.

ErrorMode

This variable determines what action is to be taken by QlikView when an error is encountered during script execution. By default (ErrorMode=1) the script execution will halt and the user will be prompted for action (non-batch mode). By setting ErrorMode =0 QlikView will simply ignore the failure and continue script execution at the next script statement. By setting ErrorMode =2 QlikView will trigger an "Execution of script failed..." error message immediately on failure, without prompting the user for action beforehand.

Example:

set ErrorMode=0;

ScriptError

Returns the error code of the last executed script statement. This variable will be reset to 0 after each successfully executed script statement. If an error occurs it will be set to an internal QlikView error code. Error codes are dual values with a numeric and a text component. The following error codes exist:

1	No error
2	General Error
3	Syntax Error
4	General ODBC Error
5	General OLE DB Error
6	General XML Error
7	General HTML Error
8	File Not Found
9	Database Not Found
10	Table Not Found
11	Field Not Found
12	File Has Wrong Format

Example:

set ErrorMode=0;

load * from abc.qvw;

if ScriptError=8 then

exit script;

//no file;

end if

Regards

Aviral Nag

Re: How to run/execute qlikview minimized

Tue, 29 Jul 2014 12:11:58 GMT

Hi.

Try this:QlikView Desktop client command line+windows scheduler

Re: How to run/execute qlikview minimized

Tue, 29 Jul 2014 12:20:17 GMT

Hi Nag,

As far as I remember errormode just skips the errors. It won't make a difference on how the model gets run.

Regards,
Marius

Re: How to run/execute qlikview minimized

Tue, 29 Jul 2014 12:22:18 GMT

Hi Goncalo,

I don't think you will get this right because when you execute a batch file the program does exactually get executed and runs as normal. Only difference was that it was run by a batch file and not by your own hand.

Regards,
Marius

Re: How to run/execute qlikview minimized

Anonymous — Sat, 02 Aug 2014 21:51:20 GMT

That's right Marius.

What Nag is suggesting is valid if I want to skip script errors.

In this case, all I want is to load qlikview (program and script window running scripts) minimized.

I couldn't find any option for that in qlikview application, not even using switches. I've also tried to install external programs that force to minimize programs, but it didn't work with qlikview so far.

I found the following thread useful, yet I wasn't able to reproduce it on my end:

Re: How to run/execute qlikview minimized

Anonymous — Sat, 02 Aug 2014 21:51:55 GMT

This thread: http://community.qlik.com/thread/8914

Re: How to run/execute qlikview minimized

hectorgarcia — Sat, 02 Aug 2014 23:03:22 GMT

I use visualcron and it works perfectly not only for this kind of task for many others

Sent from my iPhone

Re: How to run/execute qlikview minimized

Anonymous — Sat, 02 Aug 2014 23:33:50 GMT

The only workaround I can think of is to run this scheduled bat file on a separate machine. Make the folder with QV file shareable, point that "reload machine" bat to that share, reload and save there. Your main working machine not involved in the reload process at all.