topic Re: Keeping the script text separate from the document and using it in QlikView

Keeping the script text separate from the document and using it

warfollowmy_ver — Sat, 16 Nov 2024 21:36:18 GMT

There was an idea to keep the script text separately from the documents.
Why do I hope to explain it is not necessary ...

I can not yet understand how to execute the script obtained from an external source.
I am trying to do this through a subroutine, but I also don’t understand how to do it.

Who knows?

Re: Keeping the script text separate from the document and using it

jonathandienst — Tue, 15 Jan 2019 06:35:28 GMT

Use include or must_include:

In online help: Include

Re: Keeping the script text separate from the document and using it

warfollowmy_ver — Tue, 15 Jan 2019 06:56:22 GMT

That is 1 piece of script = one file .txt?

If I want to store scripts in excel or sql or somewhere other than .txt and in one file a few pieces of script?

Re: Keeping the script text separate from the document and using it

marcus_sommer — Tue, 15 Jan 2019 12:38:01 GMT

Then you do need to load it, maybe with something like:

script: load script from EXCEL where Condition = TRUE;

let script = peek('script', 0, 'script');

$(script)

This might be included in a sub-routine which might be included in a include-variable (I assume there are already multiple ones to define the standard-variables, paths, file-formattings, other routines and so on) so that you could use something like this to execute it:

call ExecuteScript(Path, Filename, Condition, WhatEver)

- Marcus

Re: Keeping the script text separate from the document and using it

warfollowmy_ver — Tue, 15 Jan 2019 12:49:37 GMT

Thank!!! Yes it worked!
I just drew attention to the highlighting red color of the expression and thought that it would not work.

$(script)