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.
jjordaan
Valued Contributor

Create qvw file which during reload executes other qvw's

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

6 Replies
MVP
MVP

Re: Create qvw file which during reload executes other qvw's

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

Re: Create qvw file which during reload executes other qvw's

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"?


talk is cheap, supply exceeds demand
jjordaan
Valued Contributor

Re: Create qvw file which during reload executes other qvw's

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
Valued Contributor

Re: Create qvw file which during reload executes other qvw's

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

MVP
MVP

Re: Create qvw file which during reload executes other qvw's

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.

Re: Create qvw file which during reload executes other qvw's

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


talk is cheap, supply exceeds demand
Community Browser