8 Replies Latest reply: Feb 1, 2016 4:33 AM by Jithu J RSS

    creating counting measure based with two date columns

    Jithu J

      I am new to Qlik ... Need help to slove the below scenario

       

      I have a table with Ticket no , created date, modified date, status (modify,submit,close) ,

       

       

      Measure :

       

      now I want to calculate how many ticket created based on time dimension ?

      and I want to calculate how many tickets closed based on time dimension ?

       

      Dimension : should be time drill down

       

      table Looks like

       

          

      Ticket nocreatedatechangeDatestatus
      127-Jan-1428-Jan-14Modify
      127-Jan-1429-Jan-14SUBMIT
      127-Jan-142-Feb-14CLOSED
      227-Jan-1428-Jan-14Modify
      227-Jan-1428-Jan-14SUBMIT
      32-Feb-142-Feb-14Modify
      32-Feb-148-Aug-14SUBMIT
      41-Mar-143-Mar-14Modify
      58-Aug-148-Aug-14Modify
      58-Aug-148-Oct-14SUBMIT
      69-Aug-149-Aug-14Modify
      69-Aug-148-Oct-14SUBMIT
      69-Aug-1411-Nov-14CLOSED
      78-Oct-148-Oct-14Modify
      78-Oct-1411-Nov-14SUBMIT
      811-Nov-1411-Nov-14Modify
      811-Nov-1411-Dec-14SUBMIT
      811-Nov-1421-Dec-14CLOSED
      911-Dec-1411-Dec-14Modify