Create an accumulative line chart showing 2 measures

[Anonymous]

Hi,

I'm trying to work out how to create a cumulative line chart that displays 2 lines showing the running totals of jobs created and jobs closed over a date/time period.  The attached show 2 charts created by developers using another product.  I'm trying to replicate these same charts in Qlik Sense.

A very small extract of my data set is as follows:

Job_Number	Job Created	Job Closed	Job Status
2017-1100	27/04/2017 16:42	27/04/2017 19:45	Completed
2017-1101	27/04/2017 16:45		Open
2017-1102	27/04/2017 16:46	27/04/2017 17:50	Completed
2017-1103	27/04/2017 16:46	27/04/2017 18:30	Completed
2017-1104	27/04/2017 16:46	27/04/2017 22:00	Completed
2017-1105	27/04/2017 16:49	28/04/2017 9:15	Completed
2017-1106	27/04/2017 16:55	27/04/2017 16:55	Referred

Any help and guidance here will certainly be appreciated.

Thanks kindly.

[karthikoffi27se · Accepted solution]

Hi Ozzie,

Try using the line chart with the below expression.

=RangeSum(Above(Count(Job_Number),1,RowNo()))

This will create a accumulative sum of the jobs that get created based on date and hours.

Many Thanks

Karthik

[Anonymous]

Hi Karthik,

Thanks kindly - you've got me on track with what I need to do.

Take care,

Ozzie