Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

Re: Create multiple dependency trigger qlikview server

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

Highlighted
Creator III
Creator III

Re: Create multiple dependency trigger qlikview server

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.?

Highlighted

Re: Create multiple dependency trigger qlikview server

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"

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)