Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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