Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

1 Solution

Accepted Solutions
amartinez35
Valued Contributor

Re: Re: Chart with cumulated number of tasks per time

See this file

4 Replies
amartinez35
Valued Contributor

Re: Chart with cumulated number of tasks per time

Hi,

You can try,

Dimension : date

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

Regards,

Aurélien

Not applicable

Re: Chart with cumulated number of tasks per time

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

amartinez35
Valued Contributor

Re: Re: Chart with cumulated number of tasks per time

See this file

Not applicable

Re: Chart with cumulated number of tasks per time

Solved !

Thank you for your help Aurélien

Community Browser