topic Avoid script stopping in QlikView

Avoid script stopping

christophebrault — Tue, 22 Nov 2011 15:35:34 GMT

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

Avoid script stopping

Tue, 22 Nov 2011 15:57:28 GMT

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

Avoid script stopping

christophebrault — Wed, 23 Nov 2011 08:27:08 GMT

Nice !

Works perfectly, thanks.