Using the QMC/QlikView Publisher, you can set up tasks like the following:
- Create a task to run the QlikView dashboard every 15 minutes
- Create a second task to run the NPrinting task on successful completion of the previous task
- The NPrinting task should have a condition on it that checks if the variable is set to 1
In this setup, the NPrinting task will run each time the document runs, but the condition will keep it from actually sending the report out.
Won't the second task continue to run every 15 minutes after the variable is set to 1?
It will be useful to know how often the task should run. If it's maximum once a day I suggest adding a second control, say a variable vDateRun which holds the value of the date when the original variable vRun is set to 1
Pseudo code something like:
IF vRun = 1 AND vDateRun = Today() THEN
vRun = 0 // NPrinting will not send out the reports because that's already been done today
IF vRun = 1 and vDateRun <> Today() THEN
vDateRun = Today() // NPrinting will send out the reports this iteration
// Next iteration the previous IF will be satisfied as long at the vDateRun is still today
HTH - Daniel.
We found an answer to this.
We set up a new task/report that saves off an Excel sheet with a single value (null if complete, 1 if not.) We added that Excel sheet into the script as a one cell data island.
The Job now has three tasks
1 - Reload
2 - Run the report with a condition set that if this new field has values, send the report
3 - Run the new report that updates the Excel sheet
This way the report sends up to and including one time where everything is refreshed.