Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to calculate the daily successful job?

Hi

I want caliculte daily how many workflow and sessions run successful and failed.

Example:i have one month data workflow name and session name, start date and end date, job status, runtime.

If user want to find the what are the jobs run successful today and present week.

How to create this requirement. Please share the solution with expression. Find the attached screenshot.

Thanks

1 Reply
Highlighted
Master II
Master II

count({<JOB_STATUS={'Success'}>} WORKFLOW_NAME)

count({<JOB_STATUS={'Fail'}>} WORKFLOW_NAME)