5 Replies Latest reply: Apr 20, 2017 2:52 AM by Martin Pohl RSS

    Count number of open tickets in a given month based on open date and closed date

    Monica Labrador

      Hi,

       

      I am new to qlik sense, and I am working on a project where I have to count the number of open tickets in a given month. Counting the number of open tickets of the current month was easy, but now I need some help with the logic of counting number of tickets closed in x month. I have the following fields: case number, status, date opened, and date closed. I want to show the data represented in a bar chart so I would have number of opened tickets per month, removing those that have been "closed/resolved" in the month. Any help is much appreciated.

       

      I created a master calendar and was thinking of having two tables containing "date opened' and "date closed" with the associated case number in it. But that's as far as I've gotten with the planning

       

          

      case_numberstatusdate_openeddate_closed
      00717139Awaiting Resolution2017-04-09-
      00717140Resolved2017-04-092017-04-10
      00717141Awaiting Resolution2017-04-09-
      00717142New2017-04-09-
      00717151New2017-04-10-
      00717152Resolved2017-04-102017-04-10
      00717153Resolved2017-04-102017-04-10
      00717154Resolved2017-04-102017-04-11
      00717156Resolved2017-04-102017-04-12
      00717155Pending Development2017-04-10-
      00717157Resolved2017-04-102017-04-11
      00717145Closed2017-04-102017-04-10
      00717158Resolved2017-04-102017-04-10
      00717159Resolved2017-04-102017-04-10
      00717160Resolved2017-04-102017-04-11
      00717161Closed2017-04-102017-04-10
      00717163Pending Development2017-04-10-
      00717164Closed2017-04-102017-04-10
      00717165Resolved2017-04-102017-04-11