topic Re. :How to identify when in batch mode? in QlikView

How to identify when in batch mode?

Tue, 20 Jul 2010 10:55:00 GMT

Hi all,

I have a macro associated with the 'OnOpen' document event but I don't want to run the code when in batch mode (that is running using the '/R' switch).

How can I detect it so that I can warap an 'if' statement around the code in the macro?

Thanks!

Gordon

Re. :How to identify when in batch mode?

martin59 — Tue, 20 Jul 2010 11:00:38 GMT

Hi,

You can modify a variable value with the batch script line.

I think it's like this :

Qv.exe /vVariableName=1 /r QvApp.qvw

Re. :How to identify when in batch mode?

Tue, 20 Jul 2010 11:13:03 GMT

Hi Martin,

Thanks for your reply - that will certainly work. I wondered if it were possible to detect the use of the /r switch directly instead though.

Regards,

Gordon

Re. :How to identify when in batch mode?

Tue, 20 Jul 2010 12:34:04 GMT

Actually, the problem with passing a variable with /v as well as using the /r switch is that the variable gets set to the passed value and the document saved with it, so you have to reset the value too.

Regards,

Gordon

Re. :How to identify when in batch mode?

Wed, 21 Jul 2010 12:41:08 GMT

Adding to Gordon's point:

Add as the last line in your loadscript a Set statement that changes your batch variable to zero (or whatever you're using for a non-batch value).