topic Re: error mode in QlikView

error mode

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

hi..can anyone explain the syntax of error mode.

i have created like this,

set ErrorMode=0;

load * from A;

if ScriptError>1 then

Load next;

end if

actually my requirement is,if the table A is error means it should skip dt one and go to next script automatically.

Re: error mode

tresB — Mon, 09 Jan 2017 05:09:13 GMT

The syntax looks good. What exactly is your issue?

Re: error mode

Anonymous — Mon, 09 Jan 2017 05:13:44 GMT

Hi Sindhu,

Please find following syntax from qlikHelp page

ErrorMode

Arguments:

Argument	Description
ErrorMode=1	The default setting. The script execution will halt and the user will be prompted for action (non-batch mode).
ErrorMode =0	QlikView will simply ignore the failure and continue script execution at the next script statement.
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;

Thanks,

Pooja

Re: error mode

engishfaque — Mon, 09 Jan 2017 05:50:13 GMT

Dear Sindhu,

Your script looks fine. Please have a look into given below I hope you are looking for that on

set ErrorMode=0;

load * from A;

if ScriptError = 1 then

load * from B;

elseif ScriptError = 2 then

load * from C;

else

exit script;

end if

Kind regards,

Ishfaque Ahmed

Re: error mode

jagan — Mon, 09 Jan 2017 06:06:01 GMT

Hi,

Try like this

set ErrorMode=0;

load * from A;

if ScriptError <> 0 then

Load next;

end if

Hope it helps you.

Regards,

jagan.

Re: error mode

jagan — Mon, 09 Jan 2017 06:07:41 GMT

or try

set ErrorMode=0;

load * from A;

if ScriptErrorCount >1 then

Load next;

end if

Regards,

Jagan.