Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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
Partner - Champion III
Partner - Champion III

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
Partner - Champion III
Partner - Champion III

or try

set ErrorMode=0;

load * from A;

if ScriptErrorCount >1 then

Load next;

end if

Regards,

Jagan.