topic Re: How to best re-use Query in Loading script? in QlikView

How to best re-use Query in Loading script?

baylor2016 — Mon, 02 Jan 2017 15:41:32 GMT

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

Re: How to best re-use Query in Loading script?

Anonymous — Mon, 02 Jan 2017 15:59:25 GMT

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

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

Re: How to best re-use Query in Loading script?

enriquem — Mon, 02 Jan 2017 15:59:36 GMT

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.

Re: How to best re-use Query in Loading script?

baylor2016 — Mon, 02 Jan 2017 16:32:28 GMT

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

Re: How to best re-use Query in Loading script?

baylor2016 — Mon, 02 Jan 2017 16:33:15 GMT

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

Re: How to best re-use Query in Loading script?

enriquem — Mon, 02 Jan 2017 16:35:07 GMT

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.