topic Re: Loading of Scripts in QlikView

Loading of Scripts

Shubham_Deshmukh — Fri, 06 Oct 2017 05:23:13 GMT

In Scripts, I am having 4 tabs for 4 differect scripts. Now, suppose I am working on table having script no. 4. When I reload the scripts,all scripts are getting reloaded. So is there any option like in MySQL or SQL Server that we can only run that selected script which we need to run at that time.

Re: Loading of Scripts

prma7799 — Fri, 06 Oct 2017 05:28:40 GMT

Multiple Tabs vs. One Long Script

Re: Loading of Scripts

tresB — Fri, 06 Oct 2017 05:30:14 GMT

You can comment out the section of script and sometimes use Exit Script command to leave out the rest of the script, like:

/* ....opening comment section

*/.... closing comment section

Exit Script;

...any script beyond this would be skipped

So, you have to use commenting and/or the exit script command.

Re: Loading of Scripts

Shubham_Deshmukh — Fri, 06 Oct 2017 05:35:43 GMT

Ya, I always do so,but I was thinking that there might be another way.

No issue.

Thanks Tresesco.

Re: Loading of Scripts

its_anandrjs — Fri, 06 Oct 2017 05:39:54 GMT

May you can try with Partial load as well as Commenting the script.

Commenting scripts are

// Line Commenting

Multiple line of code

Commenting

You can try with some of this for the script cpmments

Check some of this

What is meant by partial reload? What is its use? Please explain!

Partial Reload ‒ QlikView

Re: Loading of Scripts

marcus_sommer — Fri, 06 Oct 2017 11:58:27 GMT

Beside the already mentioned commenting of script-parts and using partial loadings you could also use if-conditions like:

if '$(vScriptTab1)' = 'run' then

script from tab 1

end if

and maintain then just the variables (by a numeric variable it might be enough to have a single variable by querying the condition with <= operators).

Another way could just be to move the script-tab appropriate and to add an exit script; on the end.

- Marcus

Re: Loading of Scripts

Peter_Cammaert — Fri, 06 Oct 2017 12:31:26 GMT

There is another way (just not a single standard switch that you can flick somewhere in a script options dialog).

See attachment.

As far as I'm concerned, it's just too much work and not worth the effort. Use IF THEN ELSE temporary conditional script activation or use Exit Script;

Re: Loading of Scripts

Shubham_Deshmukh — Tue, 10 Oct 2017 06:32:16 GMT

Thanks fr Reply. I will Try.

Re: Loading of Scripts

Shubham_Deshmukh — Tue, 10 Oct 2017 06:32:24 GMT

Thanks fr Reply. I will Try.