Chart with cumulated number of tasks per time

[#1]

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 ID	task's due_date
task1	14/10/2013
task2	15/10/2013
task3	15/10/2013
task4	15/10/2013
task5	15/10/2013
task6	16/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

[Aurelien_Martinez]

Hi,

You can try,

Dimension : date

Expression: Alt(Above(ExpressionName), 0) + Count(Distinct Task)

Regards,

Aurélien

[#3]

U mean DimensionName instead of ExpressionName ?

If it can be more clear, i'm looking for an expression that can count the number of tasks with the same date. In this way i will be able to elaborate a chart showing the evolution of the number of tasks (cumulated) over the time.

Thank you for your help

Arnaud

[Aurelien_Martinez · Accepted solution]

See this file

[#5]

Solved !

Thank you for your help Aurélien