finding backlog

Anonymous — Wed, 30 Sep 2015 02:56:49 GMT

I am new to qlikview and help me resolve the issue

Sl No	Ticket Created Month	Ticket Closed Month	Count	BackLog
1	Feb	Feb	8	No
2	Feb	Mar	12	Yes
3	Feb	Apr	2	Yes
4	Feb	May	1	Yes
5	Mar	Mar	44	No
6	Mar	Apr	16	Yes
7	Mar	May	8	Yes
8	Mar	Jun	34	Yes
9	Mar	Jul	6	Yes
10	Mar	Aug	1	Yes
11	Apr	Apr	37	No
12	Apr	May	16	Yes
13	Apr	Jun	47	Yes
14	Apr	Jul	6	Yes
15	May	May	34	No
16	May	Jun	45	Yes
17	May	Jul	9	Yes
18	Jun	Jun	48	No
19	Jun	Jul	25	Yes
20	Jun	Aug	1	Yes
21	Jul	Jul	121	No
22	Jul	Aug	24	Yes
23	Aug	Aug	43	No

I want to find the backlog count for each month by ticket created month

for eg for Feb count is 15 (which are not closed on same month would considered as backlog)

Sl No	Ticket Created Month	Ticket Closed Month	Count	BackLog
2	Feb	Mar	12	Yes
3	Feb	Apr	2	Yes
4	Feb	May	1	Yes
			15

for eg for March count is 68. which are not closed on same month will carry forward next month but eg sl no: 2 was closed on march month so that wont considered in march month count.

Sl No	Ticket Created Month	Ticket Closed Month	Count	BackLog
6	Mar	Apr	16	Yes
7	Mar	May	8	Yes
8	Mar	Jun	34	Yes
9	Mar	Jul	6	Yes
10	Mar	Aug	1	Yes
3	Feb	Apr	2	Yes
4	Feb	May	1	Yes
			68

for eg for April count is 119 (sl no. 6 was closed in apr mth so it wont carry forward to apr mth)

12	Apr	May	16	Yes
13	Apr	Jun	47	Yes
14	Apr	Jul	6	Yes
4	Feb	May	1	Yes
7	Mar	May	8	Yes
8	Mar	Jun	34	Yes
9	Mar	Jul	6	Yes
10	Mar	Aug	1	Yes
			119

topic finding backlog in QlikView

finding backlog