topic Re: run seperate tabs in script based on variable in QlikView

run seperate tabs in script based on variable

hopkinsc — Wed, 21 May 2014 12:23:56 GMT

Hi all,

If i had several tabs in the script but only want to run specific ones based on a variable how would i do this?

i.e.

1 = QVD

2 = DB

LET vScriptMode = 1

so i would want the QVD load tabs to run.

Thanks

alexandros17 — Wed, 21 May 2014 12:26:50 GMT

read the variable from an external source (e.g. xlsx file) and depending on its value write:

If myVar='QVD' then

... your script in qvd page

End if

preminqlik — Wed, 21 May 2014 12:29:56 GMT

let vScriptmode=1;

if $(vScriptMode)=1

then

(tab1 script)

else (tab2 script)

end if ;

Wed, 21 May 2014 12:31:43 GMT

Add in the tab "exit script;"

ex.

Tab1

**********************

IF $(vScriptMode) = 1 THEN

....

Load Statemets of tab1....

....

ELSE

Tab2

*************

....

Load Statemets of tab2....

....

ENDIF