topic Refer the QlickView script of one document inside other document in QlikView

Refer the QlickView script of one document inside other document

Wed, 21 Oct 2009 16:44:01 GMT

Hi All,

Can i refer the QlickView script of one existing document in other document ?

What i want here is:

I have written one script for my QV document, and i want the same script to use in other documents, so i dont want to write the same script again and again instead i want to use the existing script.

Is this possible to refer the script from other qv documents ?

I hope i am clear here.

Any suggestions will be appreaciated.

Thanks,

Mahasweta

Refer the QlickView script of one document inside other document

biester — Wed, 21 Oct 2009 16:53:10 GMT

With include you cannot directly refer to another QVW, but you can use one text (script) file for more documents, e. g.:

$(Include=script.qvs)

Rgds,
Joachim

Refer the QlickView script of one document inside other document

Wed, 21 Oct 2009 16:59:37 GMT

It can be done in 2 steps.

1) Go to EditScript of the qvw and File-> export to scriptfile and save as a .qvs

2) In the second qvw where you want to use it write the include as Biester wrote

Regards

Sravan

Refer the QlickView script of one document inside other document

Wed, 21 Oct 2009 17:09:54 GMT

Hi All,

Thanks a ton Sravan.

Could you please send me some examples for the same if you have with you ?

Thanks,

Mahasweta

Refer the QlickView script of one document inside other document

biester — Wed, 21 Oct 2009 17:19:15 GMT

Just for fun: another option would be:

In the "target" - files (where you want to use a script from another qvw) you have a module with:

1. a function retrieving the script from a given qvw
2. a sub where you modify the script of the document on open (you replace it with the script from the source qvw in my demo case)

It's a macro solution and certainly not applicable in several scenarios, but it works. Attached demo initially has no script; it requires a "source.qvw" with a script in the same directory. After opening it (the security/macro settings of course must allow it) you will see that it has the script of the qvw you defined as "source.qvw".

Rgds,
Joachim

Refer the QlickView script of one document inside other document

Wed, 21 Oct 2009 17:35:34 GMT

Hi , A simple example:

paths.txt

LET QVDdir = '..\..\QVD';

LET DATABASE = 'CRPDTA.';

...<add more default paths>

Within the QVW:

$(include=paths.txt);

--Arun

Now, this paths.txt (if in a different directory, prefix the path) can be commonly shared by all the QVWs wherever included.