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)
