Prevent Load from loading same QVD file

[ivandrago]

Hi,

I have three tasks that are currently running on the server:

CLOSED Calls:

Runs once each day at 4:00am extracting data from a MS SQL Table producing a QVD file called "Closed.qvd"

OPEN Calls:

Runs every 30 minutes from 00:15am extracting data from MSSQL Table producing a QVD file called "Open.qvd"

MyData Calls:

Runs after the OPEN Calls task has finished, this qvw loads the following QVD's "Closed.qvd" and "Open.qvd"

Is it possible not to load the Closed.qvd on the MyData Calls task everytime that Task is schedule to run, because the data for that QVD will be the same until the next CLOSED Calls task runs for the next morning.

Thanks

[ivandrago]

Anyone?

[#3]

Hi,

Look here: http://alexandrutoth.blogspot.com/2010/09/qvpr-as-directed-graph.html . There is similar case, with one reload running one per day, other reload 3 times per day, and publishing three times per day. There is other stuff as external commands

Basically set up triggers based on time, and triggers based on "successful execution"

-Alex

[vidyut]

Solution 1: You could use Binary load of another QlikVIew file which has just the Closed.qvd loaded.

Solution 2: You could use Partial Load syntax (Add/Replace), but somehow I tend to avoid these as QVD loads are generlly fast enough.