Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
timanshu
Creator III
Creator III

Create multiple dependency trigger qlikview server

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?

3 Replies
adamdavi3s
Master
Master

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
Creator III
Creator III
Author

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

May be this?

If

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


Or


If

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful