Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

christophebrault
Valued Contributor

Avoid script stopping

Hi,

I have a for each expression working fine and loading tables. But for some tables, a field is missing. When i reload, the script is stopping on each table where this field miss.

How can i solve this problem and say :" If 'this field' is missing, don't load the table."

Thanks

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Avoid script stopping

Hi There,

You could set the errormode to 0.

By default QV sets the error mode to 1. When you set the error mode to 0 QV will ignore the error and continue loading the rest of your statements/tables as required.

Use this at the start of your script.

set errormode=0;

Cheers,

Shyam

2 Replies
Not applicable

Avoid script stopping

Hi There,

You could set the errormode to 0.

By default QV sets the error mode to 1. When you set the error mode to 0 QV will ignore the error and continue loading the rest of your statements/tables as required.

Use this at the start of your script.

set errormode=0;

Cheers,

Shyam

christophebrault
Valued Contributor

Avoid script stopping

Nice !

Works perfectly, thanks.

Community Browser