topic Re: Qlikview Reload Error in QlikView

Qlikview Reload Error

anushree1 — Wed, 31 Jan 2018 13:41:09 GMT

Hi,

Could anyone let me know if its possible to make a Qlikview Reload fail by using the error modes , i tried setting it to 2 .

But i still find the reload successful

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 13:44:16 GMT

You want the reload to fail? May be just add something like this at the point you want it to fail

adakjdhajdhaskj

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 13:45:00 GMT

This is what I got

Re: Qlikview Reload Error

anushree1 — Wed, 31 Jan 2018 13:47:50 GMT

ya sure, but is there a cleaner way to do this using the error mode variables or so

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 13:49:33 GMT

Error_Mode is used for when there is an error, it can't throw an error for you.

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 13:50:00 GMT

Read here on what error mode does

ErrorMode ‒ QlikView

Re: Qlikview Reload Error

anushree1 — Wed, 31 Jan 2018 13:51:35 GMT

Ya sure, i get that but was looking for a variable that does a reverse of this.

So is there anything of that sought.

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 14:04:23 GMT

I don't think so... but let's see if hic‌ or rwunderlich‌ know anything.

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 14:05:06 GMT

You can Exit the script using EXIT SCRIPT;... or do you want it to actually fail? Can you explain the use case for this?

Re: Qlikview Reload Error

anushree1 — Wed, 31 Jan 2018 14:09:15 GMT

I actually want it to fail as in case the other developer hits run task on qmc the reload does'nt happen.

WE have multiple tasks with very similar names

Re: Qlikview Reload Error

sunny_talwar — Wed, 31 Jan 2018 14:10:45 GMT

Why don't you just add EXIT SCRIPT at the very start of your unwanted qvws?

Re: Qlikview Reload Error

Anonymous — Wed, 31 Jan 2018 15:26:11 GMT

Something like this is a little cleaner, allows you to set/unset the variable to trigger the failure and allows a custom message which will be visible in the Log file.

Let vFailScript = 1;

IF $(vFailScript) = 1 THEN

Trace Custom Error Triggered;

SET [Error 1001 - My Custom Error is now Triggered];

END IF;