Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Script to avoid specific tabs

Is there a way to automated within a script to skip a tab. I have script that doesn't have to be run each time and want to put in something so when the script is run it can skip over a tab(s)?

7 Replies
jolivares
Specialist
Specialist

the best way i found is to declare every tab as a subroutine, in this case I control the call for each one.

Sub Tab1

...

EndSub

Call Tab1

Not applicable

Hi,

I use the 'If..then..elseif..else..end if'statement.

Example form the reference manual:

Examples:

if a=1 then

load * from abc.csv;

sql select e, f, g from tab1;

end if

if a=1 then; drop table xyz; end if;

Regards,

Gerrit

zagzebski
Creator
Creator
Author

So just wrap all the script around the if statement (on the tabs I may want to skip).  Set A = 0 or 1? Then if A =1 it skips and if 0 if runs the script?

Not applicable

Yep.

jolivares
Specialist
Specialist

ok... mark a answered...please

CELAMBARASAN
Partner - Champion
Partner - Champion

You can move the tabs(that need to skipped) to the end and use Exit Script; before the scripts to be skipped.

Not applicable

ok... mark a answered...please

That's up to you. Only you may do that.