How to best re-use Query in Loading script?

[baylor2016]

Hi Everyone,

Happy New Year.

In my loading script, I need to re-use a query many times since all the queries used will depend upon this query. Currently I just copy this query and include in in with statement. It works fine, but if I need change many times if there are any changes made to this query. I think there should be a better way to do it, use QVD or resident load or save this query to a text file? Please advise.

Thanks

Longmatch

[Anonymous · Accepted solution]

An Include file could help, have a look at this Blog Post,

      The $(Include) which you $(Must_Include) into your toolkit

[enriquem]

Hi,

why you don't try to build a qlikView script (qvs) out of your project and at the first of your project call this:

$(Include=..\3.Include\FilePath.qvs);

And finaly in your project you can call all the function, variables o whatever in the qvs.

To learn more about structured Qlik Proyect, I recommended you to see the QlikView Deployment Framework (QDF).

Hope this helps,

Regards.

[baylor2016]

The INCLUDE functions works for me, what is the difference between $(Include) and $(Must_Include)?

[baylor2016]

qvs and QDF are pretty new to me. I will learn that in the future. Thanks

[enriquem]

The difference between include and must_include is that include will fail silently if the file is not found during script reload, while must_include will throw an error if the file is not found.