topic Use an include file in the script in QlikView

Use an include file in the script

Wed, 30 Jun 2010 17:31:54 GMT

Hi all,

Is it possible to use an include file in the script? For example, I have a bunch of reference data which I tend to load into every QV file. I have this already loaded into qvd's so at the moment I just do:


Load *
FROM c:\myFiles\myRefData1.qvd
Load *
FROM c:\myFiles\myRefData2.qvd
Load *
FROM c:\myFiles\myRefData3.qvd

etc. But it would be really nice if I could just put all that in a text file and have something like this in my script:


&include c:\myFiles\myRefData.txt

Can I do something like this?

TIA,

Tony

Use an include file in the script

Wed, 30 Jun 2010 17:48:46 GMT

You can do this:

<pre>
myRefData:
Load *
FROM c:\myFiles\myRefData1.qvd;
Concatenate
Load *
FROM c:\myFiles\myRefData2.qvd;Concatenate
Load *
FROM c:\myFiles\myRefData3.qvd;

Store myRefData into c:\myFiles\myRefData.qvd (qvd);

And after that you can use it in any dashboards like:

<pre>Load *
FROM c:\myFiles\myRefData.qvd;

Use an include file in the script

Anonymous — Wed, 30 Jun 2010 18:15:11 GMT

In fact, there is possibility to use include. It is under Edit menu in Edit Script. Or just type:
$(Include=c:\myFiles\myRefData.txt)

Use an include file in the script

Wed, 30 Jun 2010 18:18:00 GMT

The syntax for an include is

<h4>$(Include = filename )</h4>

so in your case would be

<h4>$(Include = c:\myFiles\myRefData.txt );</h4>

edit: Michale was quicker on the post button it seems lol

Use an include file in the script

Anonymous — Wed, 30 Jun 2010 18:30:36 GMT

Qowboy,
I'm not a quicker qliker, just happend to read it a few min before you...

Use an include file in the script

Thu, 01 Jul 2010 09:30:06 GMT

Thanks Nick, but I probably should have said that the different RefData files are not related and could not be concatenated.

cheers,

Tony

Use an include file in the script

Thu, 01 Jul 2010 09:31:26 GMT

Thanks Michael (and SQL Cowboy) - that's just what i was looking for.

cheers

Tony