topic Re: Skip parts in Load Script in QlikView

Skip parts in Load Script

Thu, 18 Oct 2012 11:36:43 GMT

Hello together

is it possible to skip a part in a load script.

Ex: IF NOOFROWS('TEST') = 0 THEN "Skip this Sheet, or Skip this Code, or GoTo another part of Code?

This would be easier than:

IF NOOFROWS('TEST') > 0 THEN

Here comes the Code

ENDIF;

Less Code and no nesting.

Any Idea how to?

Thanks in adv.

Ramon

Re: Skip parts in Load Script

Miguel_Angel_Baeyens — Thu, 18 Oct 2012 12:25:00 GMT

Hi Ramon,

If I got your question right, what you want is to prevent the execution of some part of your script depending on certain condition. Then the answer is that you must use the IF ... THEN ... END IF and all the code you want to execute (or prevent execution) in between. You can warp entire tabs, but take into account that the script, although you see it in tabs, is sequential and executed line by line and goes from the first line in the first tab at the left to the last line in the last tab on the left.

Tabs are only visual hints, the script (you will see it if you export it to a QVS file) is only one.

Feel free to create an idea to propose a new feature in the Ideas section.

Hope that makes sense.

Miguel

Re: Skip parts in Load Script

Mon, 22 Oct 2012 09:19:16 GMT

Hi Miguel

Thanks for your reply.

Surely I'm familliar with the conditioinal functions like IF, SWITCH etc. but in big blocks of code you ever habe to indent. So in some cases the code will be to much nested to read. What I ment is a funcion like "Exit Script/Sub/For/Do".

In the same funcional way could be a function like "Exit IF/SWITCH".

For example:

CurrTable = 'TableName';

If Exists('DisplayName','$CurrTable)') then

here comes the code (many lines and nests)

....

EndIf;

In the other case you could do it like:

If not Exists( ........) then Exit "CurrentSheet", or "Exit ....."

At the moment I solved the issue with Sub(), Exit Sub(), but it's a workarround ...

I know, it's more a nice to have issue, but if they had been a solution I had taken that. 🙂

PS: Sorry for my english 🙂

Greetings

Ramon

Re: Skip parts in Load Script

flipside — Mon, 22 Oct 2012 09:40:25 GMT

Hi Ramon,

Not sure if this is a solution, but would calling the code using INCLUDE statements help? My idea is to break the code up into separate qvw documents which have their own -prj folders, so ScriptA.qvw code would be called by ScriptB.qvw ...

$(Include=ScriptA-prj\LoadScript.txt);

flipside

Re: Skip parts in Load Script

Miguel_Angel_Baeyens — Mon, 22 Oct 2012 10:05:25 GMT

Hi Ramon,

Yes, there is a EXIT keyword to be used in the script. Check this example or this example to see how it works.

Hope that helps.

Miguel

Re: Skip parts in Load Script

Mon, 22 Oct 2012 10:53:48 GMT

Hmm, got it, but with Exit Script (condition) you will kick out of the whole script, and that's not what I'm looking for. Only Jump over a passage of code.

But with the idea from flipside it work's. It's also a workarround, but to export some script in text, load it with $Include and overjump some $Included files.

That's ok for this case and the customer as well. So I can load all Files with "*.txt* and choose, which file should be loaded or should be skipped. So it's not necessary to jump into script.

If (condition) then

$Include;

endif;

regular code ...

Thanks @Miguel and @flipside

Greetings from Switzerland

Ramon

Re: Skip parts in Load Script

lfg — Wed, 06 Mar 2013 20:54:45 GMT

Hi Ramon,

You can use a variable

For Example:

Let vLine = if(Condition,'','Exit Script');

$(vLine)

If condition is false $(vLine) will be replace with Exit Script and the Script will stop.

Greetings

Fernando

Re: Skip parts in Load Script

6982blakey — Thu, 03 Nov 2022 08:02:41 GMT

I know this is a really old post, but I use a fairly tidy workaround.

I have a section called 'Skip from...' with the code 'If 1=2 Then'

Next comes all the sections of code I may or may not want to run.

Finally, a section called '...Skip to' with the code 'Endif'

(I use this for testing parts of script when I don't want to re-order sections or use 'exit script')