Discussion Board for collaboration related to QlikView App Development.
I have data relating to call activity. Showing new calls opened and closed per day. I need assistance with a chart table to get the correct balance brought forward (b/f) which is dependent on the balance carried forward(c/f) from the previous day.
Balance b/f + New Open Calls = Total Open Calls - Closed Calls = Balance c/f
So for eg, at the end of 30 Aug 2016, the balance c/f is 1, and the balance brought forward for 31 Aug 2016, should be 1, however I'm struggling to get it right. I've tried below function with no success. For now, I let it equal to 0 for simplicity.
I have attached the data and the model and also attached is an Ideal Solution (in excel) that the chart table in Qlikview should look like.
Your help will be appreciated.
One more query, If I select a particular date, the balance b/f should be an accumulated balance carried forward of previous day and should not revert to zero. Or if i restrict the chart to last 7 days, the balance brought b/f should also be accumulation of all open calls up to that date.
Below are screen shots:
How do you achieve this.
Can you assist again. Thanks
Thank you for quick response. It works. One more query, regarding the last 7 days chart table, if I select a date say , 12 Sep , I want the table to show last 7 days from the 6th to the 12th, bearing in mind that the 6th Sep balance b/f should be the accumulation of previous days.