topic Re: How to fail? in QlikView

How to fail?

Fri, 16 Oct 2015 13:41:21 GMT

Hello,

Is there a good way (apart from deliberate faulty code) to make a script execution fail?

E. g., when some checking condtion is not met.

("exit script" is not what I want, since it merely exits without failing)

Re: How to fail?

crystles — Fri, 16 Oct 2015 18:44:50 GMT

If you just want the script to fail, leave off the end of load statement symbol = ;

I know I've done it before... on accident usually though.

Re: How to fail?

maxgro — Fri, 16 Oct 2015 18:47:52 GMT

No AFAIK.

There isn't a raise, exception or similar thing in Qlik to jump to an outer script section.

Actually, I don't see a reason you can't use a "deliberate faulty code" (example load from notexists.qvd) to make a script execution fail. Can you explain a little more in detail?

Re: How to fail?

Fri, 16 Oct 2015 18:57:01 GMT

can you please explain what you are trying to do?

If you set a condition tht will nexver be met, such as your example, that does not make the script fail since it is chedking a condition that is not met -

Re: How to fail?

Fri, 16 Oct 2015 19:09:42 GMT

please see the attached thread - it may be of some help

How can I intentionally create a script error?

Re: How to fail?

Qrishna — Fri, 16 Oct 2015 19:16:36 GMT

See attached.

(Not sure if you need that.)

Re: How to fail?

chaudhariv — Fri, 16 Oct 2015 19:35:34 GMT

You can use the

SET ErrorMode= 0;

ErrorMode takes 0,1,2 and other values depending on your requirement.

Re: How to fail?

Mon, 19 Oct 2015 08:40:37 GMT

Thanks all for useful answers! The conjuntion of the answers this far answers my question - I can use ErrorMode=2, and then intentionally write faulty code such as load * from bozofilename.qvd.

One of use of this is that in QMC i can have other tasks have different triggers depending so that some are triggered on the first ones success and others on failure in a more controlled manner.