Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

error mode

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.

5 Replies
tresesco
MVP
MVP

The syntax looks good. What exactly is your issue?

Anonymous
Not applicable
Author

Hi Sindhu,

Please find following syntax from qlikHelp page

ErrorMode

Arguments:

ArgumentDescription
ErrorMode=1The default setting. The script execution will halt and the user will be prompted for action (non-batch mode).
ErrorMode =0QlikView 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

engishfaque
Specialist III
Specialist III

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

set ErrorMode=0;

load * from A;

if ScriptError <> 0 then

Load next;

end if

Hope it helps you.

Regards,

jagan.

jagan
Luminary Alumni
Luminary Alumni

or try

set ErrorMode=0;

load * from A;

if ScriptErrorCount >1 then

Load next;

end if

Regards,

Jagan.