How to calculate the duration of past 10 successful executions of a job in QlikView

[#1]

Hi All,

I am trying to calculate the duration of past 10 successful executions of a job in Qlik View and draw a line chart for that. Can someone please guide me how to proceed with this ?

I have the current field values like Status_code, End_time, Start_time. I can calculate the duration using End_time and Start_time but how to find out the last 10 successful executions of the job.

I want something like shown in the screenshot below

Thanks,

Kshitij

[avinashelite]

Try like this :

Create two variables, vStart and Vend ..difference between this will give you the duration of the reload.

and then on every reload you need to store this total time into a QVD with the time stamp so that every time when you reload the duration will be captured in the QVD and you can load this QVD to create your chart

[PradeepReddy · Accepted solution]

see the attachment, it might be helpful..

[HirisH_V7]

Hi ,

I hope you require to show line chart for all 10 status codes and duration of the Execution .

check this,

Info:

Data:
LOAD * ,
Interval(EndTime-StartTime,'ss[.fff] ') As Duration
INLINE [
    StatusCode, StartTime, EndTime
    1,19/01/2016 8:59:01 AM,19/01/2016 9:59:01 AM
    2,19/01/2016 9:59:09 AM,19/01/2016 10:59:01 AM
    3,19/01/2016 11:58:09 AM,19/01/2016 11:59:01 AM
    4,19/01/2016 12:58:09 AM,19/01/2016 12:59:01 AM
    5,19/01/2016 1:51:09 AM,19/01/2016 1:59:01 AM

];

Output:

Hope you require like this,

Else post your sample data,

PFA,

Hirish

[#5]

Thanks all for your prompt replies. Pradeep's attachment worked fine for me as my data was same as his. Problem resolved.

Cheers!!!!

Kshitij