4 Replies Latest reply: Oct 17, 2013 5:18 AM by Arnaud Klr RSS

    Chart with cumulated number of tasks per time

      Hey everyone,

       

      I would like to create a chart that shows the cumulated number of tasks per time ( Y-axis = # tasks and X-axis = date

       

      Let me give you an example:

         

           In my source file i have a lot of rows; each row is a task with a due date.

       

      Task IDtask's due_date
      task114/10/2013
      task215/10/2013
      task315/10/2013
      task415/10/2013
      task515/10/2013
      task616/10/2013

       

      I would like that the graphic shows that:

           the 14/10 i have 1 task (1 on the Y-axis)

           the 15/10 i have 5 tasks (1 from 14/10 + 4 tasks from 15/10)

           the 16/10 i have 6 tasks (1 from 14/10 + 4 tasks from 15/10 + 1task from 16/10)

       

           and so the line will show the evolution of the number of task by time.

       

      My problem here is to define which expression enters to show this.

       

      I hope this is clear. (Sorry i'm new on Qlikview)

       

      Best regards,

       

      Arnaud