0 Replies Latest reply: Sep 29, 2015 10:56 PM by Ramu Subramaniyan RSS

    finding backlog

    Ramu Subramaniyan

      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