topic Re: Create multiple dependency trigger qlikview server in QlikView

Create multiple dependency trigger qlikview server

timanshu — Wed, 15 Mar 2017 11:43:36 GMT

Hi All,

How can I create multiple dependent tasks in qlikiew server.

Example 3 tasks are there. A, B and C. I want C to execute after completion of A and B.

Please note : I have server licence only in QMC. No publisher license is there.

With publisher, I know how to do but with Server, what is the way?

adamdavi3s — Wed, 15 Mar 2017 13:34:05 GMT

The way I would do this is to get A and B to create QVDs with a single field called FLAG and set it to 1 when they have reloaded.

In C, load these into variables and if the sum of the two variables <> 2 then EXIT SCRIPT

Then at the end of C write back these QVD with a flag of 0

Either that or much simpler (if your setup allows it) load:

A > B > C using the 'on successful completion' option in the reload schedule

timanshu — Thu, 16 Mar 2017 07:26:56 GMT

Thanks Adam,

But that will not work I have hundreds of qvw.

But thanks for your inputs.

I would like to know server has this limitation that it does not have option for multiple dependency of tasks.?

Anil_Babu_Samineni — Thu, 16 Mar 2017 07:50:19 GMT

May be this?

"C:\Program Files\QlikView\qv.exe" /R "a.qvw"

if %errorlevel% NEQ 0 (

exit /b 1)

"C:\Program Files\QlikView\qv.exe" /R "b.qvw"

if %errorlevel% NEQ 0 (

exit /b 2)

Then

"C:\Program Files\QlikView\qv.exe" /R "c.qvw"

if %errorlevel% NEQ 0 (

exit /b 3)

Else

TRACE "Dependency Trigger failed in Qlikview Server"

"C:\Program Files\QlikView\qv.exe" /R "a.qvw" || GOTO : eof

"C:\Program Files\QlikView\qv.exe" /R "b.qvw" || GOTO : eof

Then

"C:\Program Files\QlikView\qv.exe" /R "c.qvw" || GOTO : eof

Else

TRACE "Dependency Trigger failed in Qlikview Server"