hi
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 | |