Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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)
Go to Solution.
See this file
You can try,
Dimension : date
Expression: Alt(Above(ExpressionName), 0) + Count(Distinct Task)
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
Thank you for your help Aurélien