Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ramusubramani
New Contributor II

finding backlog

hi

I am new to qlikview and help me resolve the issue

   

Sl NoTicket Created MonthTicket Closed MonthCountBackLog
1FebFeb8No
2FebMar12Yes
3FebApr2Yes
4FebMay1Yes
5MarMar44No
6MarApr16Yes
7MarMay8Yes
8MarJun34Yes
9MarJul6Yes
10MarAug1Yes
11AprApr37No
12AprMay16Yes
13AprJun47Yes
14AprJul6Yes
15MayMay34No
16MayJun45Yes
17MayJul9Yes
18JunJun48No
19JunJul25Yes
20JunAug1Yes
21JulJul121No
22JulAug24Yes
23AugAug43No

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 NoTicket Created MonthTicket Closed MonthCountBackLog
2FebMar12Yes
3FebApr2Yes
4FebMay1Yes
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 NoTicket Created MonthTicket Closed MonthCountBackLog
6MarApr16Yes
7MarMay8Yes
8MarJun34Yes
9MarJul6Yes
10MarAug1Yes
3FebApr2Yes
4FebMay1Yes
68

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

   

12AprMay16Yes
13AprJun47Yes
14AprJul6Yes
4FebMay1Yes
7MarMay8Yes
8MarJun34Yes
9MarJul6Yes
10MarAug1Yes
119
Tags (1)
Community Browser