topic Re: How to exit the script based on condition? in QlikView

How to exit the script based on condition?

dineshmdane — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

Exit the script based on condition on reload.

For Example:

if 'Id' is equal to 37 then the script should continue execution

else the script should stop its execution at that point and 'EXIT Script' should be activated or executed.

Kindly awaiting for your response.

Thanks & Regards,

Dinesh M

Re: How to exit the script based on condition?

sunny_talwar — Wed, 09 Nov 2016 14:19:17 GMT

What is Id here? Is this a field or a variable?

Re: How to exit the script based on condition?

Anonymous — Wed, 09 Nov 2016 14:33:49 GMT

if (id=37) then

EXECUTE

else

LET vStop = Now();

EXIT Script;

End If

just try like this it may works

Re: How to exit the script based on condition?

Anil_Babu_Samineni — Wed, 09 Nov 2016 14:46:06 GMT

Can you share full script? I mean before IF condition what you have done

Re: How to exit the script based on condition?

its_anandrjs — Wed, 09 Nov 2016 14:56:18 GMT

Try this way


LET X = 37;
 LET vVar = 37;
 
 if $(X) = $(vVar) then
 
 LOAD * Inline [
 Col
 a
 b
 c
 d ];
 
 else
 
 EXIT Script;
 
 end if

Regards

Anand

Re: How to exit the script based on condition?

dineshmdane — Thu, 10 Nov 2016 05:08:42 GMT

Hi Sunny,

'Id' is a field for which the values are given using input function.

Regards,

Dinesh M

Re: How to exit the script based on condition?

sunny_talwar — Thu, 10 Nov 2016 10:13:22 GMT

Can it always have one value assigned to it? Can you may be share a sample so that we can see your setup?

Re: How to exit the script based on condition?

dineshmdane — Thu, 10 Nov 2016 10:30:41 GMT

Kindly find the below script that I have and there is no binary load.

LOAD

Input('Enter your ID','Input' ) as ID,

Input('Enter the Name','input' ) as Name

AutoGenerate(1);

//----------------

// condition

//----------------

//-------------------------

// remaining script

//--------------------------

if the condition is true the 'remaining script' has to execute else script has to exit.

Thanks & Regards,

Dinesh M