Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

Some way to skip part of load script during load

During testing i want to skip some load calls in loadscript

i do now , wich works , but not handy due to editting to activate or not-activate

by placing this at front   //rem  

is there a way to have a goto or dummy statement before first line where i want to quit loading

e.e. something like

 

Goto FromHereOk

then under last remmed the label?

 

load
Groepnr as Hoofdgroep15 ,
SubGroepnr as SubGroepnr15 ,
Text1 as Omschrijving15 ,
Volgorde as Volgorde15 ,
Aanuit as AanUit15;
//rem SQL SELECT * from HOOFDGROEPEN;

load
Groepnr as Hoofdgroep16 ,
SubGroepnr as SubGroepnr16 ,
Text1 as Omschrijving16 ,
Volgorde as Volgorde16 ,
Aanuit as AanUit16;
//rem SQL SELECT * from HOOFDGROEPEN;

load
Groepnr as Hoofdgroep17 ,
SubGroepnr as SubGroepnr17 ,
Text1 as Omschrijving17 ,
Volgorde as Volgorde17 ,
Aanuit as AanUit17;
//rem SQL SELECT * from HOOFDGROEPEN;

load
Groepnr as Hoofdgroep18 ,
SubGroepnr as SubGroepnr18 ,
Text1 as Omschrijving18 ,
Volgorde as Volgorde18 ,
Aanuit as AanUit18;
//rem SQL SELECT * from HOOFDGROEPEN;

Labels (2)
1 Solution

Accepted Solutions
Taoufiq_Zarra

@JACKNIEKERK 

Have you tried using Sub ...end sub , then apply the subroutine  according to a variable .

or Switch..case..default..end switch, like this example from help :

Switch I

Case 1

LOAD '$(I): CASE 1' as case autogenerate 1;

Case 2

LOAD '$(I): CASE 2' as case autogenerate 1;

Default

LOAD '$(I): DEFAULT' as case autogenerate 1;

End Switch

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@JACKNIEKERK 

Have you tried using Sub ...end sub , then apply the subroutine  according to a variable .

or Switch..case..default..end switch, like this example from help :

Switch I

Case 1

LOAD '$(I): CASE 1' as case autogenerate 1;

Case 2

LOAD '$(I): CASE 2' as case autogenerate 1;

Default

LOAD '$(I): DEFAULT' as case autogenerate 1;

End Switch

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
JACKNIEKERK
Creator
Creator
Author

True, i did place all not wanted in the case i  (then is dummy value)   loop

all between start and and case are the line now remmed , they can stay on due to being ignored in the case loop

Thanks for advice

Regards Jack