Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load multiple qvd dependencies files from one qvw

Hello wonderful community,

I have a qvw document which has 10 dependent QVDs. Rather than create 10 taks in QMC, is there a way to create one task that will load all dependencies?

I know I can create tasks that will run upon the successful completion of another task but this is still clunky and clogs up the QMC task list.

In development my solution was to simply create a batch file that reloads all dependencies, I was thinking of executing a batch file from within a qvw but I am sure the community can come up with a more elegant solution than that??

Thanks lovely people

Tags (3)
4 Replies
Not applicable

Re: Load multiple qvd dependencies files from one qvw

Hi all

Disappointing response so far guys, have to be honest :-( (that’s a sad face right there)

The best solution i have come up with so far is to fire off execute statements like so:

 
EXECUTE c:\Program Files\QlikView\qv.exe /r c:\reports\reloadtest.qvw

The reload works fine in desktop mode, however, when run via a distribution task the load fails. Each dependent qvw file just hangs.

Any ideas most welcome guys.

L for love

paputzback
New Contributor II

Re: Load multiple qvd dependencies files from one qvw

No response?

Not applicable

Re: Load multiple qvd dependencies files from one qvw

Hi Andrew,

You have at the moment 10 seperate qvw's each generating just one QVD?

Is there a reason why you cannot create a single QVD builder QVW  for all 10 of the required QVD creation?

Or at the very least group up some of the QVD's into common qvd builders.

One qvw for all fact QVD's, one qvw for dimension QVD's

Joe

paputzback
New Contributor II

Re: Load multiple qvd dependencies files from one qvw

Joe,

What happens when one QVD fails out of many in a builder. If you rerun the QVD generator does it know which QVDs were already ran? Is there a best practice for how many QVDs should run at once? And I can't remember if the scripts run sequentially in a QVD Generation app. We took training a few months ago and then started work on the data warehouse and are several months away from getting to the QVD side of the project. Once of those cart before the horse plans.

Community Browser