Need help with running total calculation

Fri, 22 May 2015 10:47:17 GMT

Hi All,

I have uploaded the source file through which I am trying to achieve the below.

Number of cases OPENED on each day during the last 15 days

Number of cases CLOSED on each day during the last 15 days

Total Number of cases OPEN at the end of each day for the last 15 days

In a straight line chart I can show by date the cases Opened and closed with the correct overall totals

I can also show in bar chart form the cases Opened and Closed each day in the last 15 days

I can’t show the total cases which are open on any given day – the line graph only shows the number of cases opened each day not the running total of each day

Eg on April 30 it should be 5 opened – 2 closed = 3

So at the end of May 1 it should be 3 + 2 new cases opened = 7

on May 2 it should show 7 + 3 new cases opened = 10

on May 3 it should show 10 – 1 case closed = 9

on May 4 it should show 9 + 1 case opened – 1 case closed = 9

on May 5 it should show 9 + 1 cases opened – 1 case closed = 9

and then 9 cases open until the end of the month

Any idea how to show this – preferably all on the one chart – ie barchart for the opened and closed as below plus a line chart for the running total opened cases?

Any suggestions appreciated

Thanks

Jyothi

Re: Need help with running total calculation

Gysbert_Wassenaar — Fri, 22 May 2015 12:46:55 GMT

See attached qvw

Re: Need help with running total calculation

Mon, 25 May 2015 14:10:50 GMT

Thanks So much Gysbert for the reply.

topic Need help with running total calculation in QlikView

Need help with running total calculation

Re: Need help with running total calculation

Re: Need help with running total calculation