Create qvw file which during reload executes other qvw's

[jjordaan]

Hello everyone,

What I'm trying to accomplish is the following thing.

I have 3 QVDLoaders.

If the QVDLoaders are all finished then the dashboard needs to reload.

I want to create a qvw (let's call it ExecLoader) that during the reload executes the 3 QVDLoaders.

I think it needs to be done with a macro but I don't have much knowledge about Macro's.

And the created qvw (ExecLoader) needs to be scheduld in the QlikView Server (SBE).

I heard that you can't executes macro's with the QlikView Server but like a said I don't have much knowledge about macro's

I hope someone can help me.

Thanks in advance

[swuehl]

Why don't you just let the Server execute the Reloads?

[Gysbert_Wassenaar]

You can chain tasks so that a task will reload when the task up in the chain succesfully reloaded. You can set these On event of another task dependencies on the reload schedule page. See this discussion for a screenshot and some information: Scheduling of documents // "On event of other task" AND/OR "dependency"?

[jjordaan]

Hi Swuehl,

the qvw' are executed by the Server.

The reason why I'm looking for such a solution is because the duration per QVDLoader is approximately 1 till 1,5 hour.

So If I will execute it sequentel it will take to long

[jjordaan]

Hi Gysbert,

The duration per QVDLoader is approximately 1 till 1,5 hour.

So the dependency needs to be on all 3 QVDLoaders. IF they alle reloaded woth succes then reload of the dashboard Should start.

I don't think you can set a dependency on multiple qvw' s

[swuehl]

I don't think you can execute the 3 qvd generators in parallel from your ExecLoader, so you will end up for a sequential load here, too.

You can create three parallel tasks in your server, then create a trigger OnSuccess on the longest running one (assuming there is one task that is always running longer than the other two), or create a logic in your following task that checks for successful execution of all three tasks in a loop, e.g. checking a status file / DB.

[Gysbert_Wassenaar]

I think you'll have to use EDX for this. See this document: Using EDX in QlikView 11.