topic Re: qvw calling other qvws in QlikView

qvw calling other qvws

Sun, 10 Nov 2013 16:19:23 GMT

can you have a qvw such that it will call another qvw to reload its script (which creates qvds) and then reload its own script?

I want to have one qvw that simply makes qvds. Let's call it qvw2.

Then I want a qvw that users access, called qvw1 that calls qvw2 before reloading its own script on a schedule. (qvw1 uses qvds made by qvw2.)

Message was edited by: Chris Rockhill

Re: qvw calling other qvws

Anonymous — Sun, 10 Nov 2013 16:42:11 GMT

Hi Chris

Do you have QlikView Publisher? if yes, users can trigger reload of QVW files using EDX triggers

Also, you can create a button with action that calls QV.exe /r <QVW2 filename> and it should work - this is only for developers who open the QVW file and not users (via access point / open in server etc...)

Yaniv

Re: qvw calling other qvws

rustyfishbones — Sun, 10 Nov 2013 16:50:10 GMT

Hi Chris,

Yes create a Qlikview File that does the Extraction of Data.

Create another that does the Transformation of Data

And then the Qlikview file itself that reads all the transformed QVD's

but you would call the qvd's each time, not the qvw!

You can reload a qvw into another qvw by using Binary load, but you can only use that once per qvw

I made a video, Importing Qlikview into Qlikview on youtube, check it out, it may help

Regards

Alan

Re: qvw calling other qvws

Sun, 10 Nov 2013 21:00:04 GMT

If you don't have the Qlikview Publisher, You can use BATCH load option to reload the the qvw's

Re: qvw calling other qvws

Tue, 12 Nov 2013 14:29:51 GMT

Thanks everyone. That gave me some ideas.

Re: qvw calling other qvws

datanibbler — Tue, 12 Nov 2013 14:43:39 GMT

Hi Chris,

we have a similar scenario here. We neither have the Publisher nor do we use any BATCH files on the server.

We have the QV management_console - that comes with the Small_Business_Server, I think - and in that, we can schedule QlikView apps. We have a three-tier architecture consisting of

- primary data_loading_apps that load data from the database and store it as qvd files.

- A data_Model loading all the qvd files (we're going to have several app-specific data_models going forward to avoid loading all the data in the "big" data_model when the final app needs only very little)

- the final (user-) qvw files accessing the Data_Model.

Re: qvw calling other qvws

Tue, 12 Nov 2013 15:15:48 GMT

You can also try:

$(Must_Include=..\Scripts\ExternalScript.qvw);