Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this file
Hi,
You can try,
Dimension : date
Expression: Alt(Above(ExpressionName), 0) + Count(Distinct Task)
Regards,
Aurélien
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
See this file
Solved !
Thank you for your help Aurélien