topic Re: Script to avoid specific tabs in QlikView

Script to avoid specific tabs

zagzebski — Sun, 10 Nov 2013 21:52:15 GMT

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)?

Re: Script to avoid specific tabs

jolivares — Sun, 10 Nov 2013 22:29:16 GMT

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

Re: Script to avoid specific tabs

Sun, 10 Nov 2013 22:51:57 GMT

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

Re: Script to avoid specific tabs

zagzebski — Mon, 11 Nov 2013 12:55:12 GMT

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?

Re: Script to avoid specific tabs

Mon, 11 Nov 2013 12:58:05 GMT

Yep.

Re: Script to avoid specific tabs

jolivares — Mon, 11 Nov 2013 14:29:32 GMT

ok... mark a answered...please

Re: Script to avoid specific tabs

CELAMBARASAN — Mon, 11 Nov 2013 14:39:00 GMT

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

Re: Script to avoid specific tabs

Mon, 11 Nov 2013 14:44:35 GMT

ok... mark a answered...please

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