topic Re: Bar Chart with accomplished tasks in QlikView

Bar Chart with accomplished tasks

Anonymous — Thu, 11 Jan 2018 21:57:34 GMT

Hello QV Experts,

I need to create metric showing performance of tasks each working day.

Tasks are done by 3 people:

- first person working from 0:00 till 7:59

- second person working from 8:00 till 15:59

- third person working from 16:00 till 23:59

In the X-axis I have days, each day contains three bars (1,2,3 person) and they show performence (amount of tasks done that day/all task assigned to the person that day)

If the task comes on 22/12/2017 16:30 it should be done by person 3, but if it has not been done by person 3 it should goes to person 1 (if done by person 1 it should be included to his performence as task done on 23/12/2017), afterwards (if still not done) to person 2 and so on unitl the task is completed

Example of the table:

Task	TaskStartDate	TaskEndDate
task1	22/12/2017 16:30	23/12/2017 11:00
task2	09/01/2018 12:20	null
task3	06/01/2018 06:00	null
task4	12/12/2017 15:00	13/12/2017 14:00
task5	14/12/2017 9:00	15/12/2017 6:00
task6	03/12/2017 14:00	6/12/2017 11:00

I have problem with the script. How to make that task (TaskStartDate) will be moving from one person to another until is done? Should I use some loop? Could you please advise how it should look like?

Thanks in advance for your comments

Re: Bar Chart with accomplished tasks

uacg0009 — Fri, 12 Jan 2018 07:01:16 GMT

Hi Krzysztof,

Because I don't have the real data and real data model, but according to what you said,

I think maybe you need to see the data from another perspective. Because I think according to you said, just when the task is done, then you know whom the task really belong to.

So for the tasks that is not done. if your dashboard is real-time, I think you can try to join these tasks to the different person according to the time.

If what I understood is wrong, please let me know. And if you can give a scenario, that would be better.

Thanks.

Aiolos

Re: Bar Chart with accomplished tasks

Anonymous — Fri, 12 Jan 2018 11:17:05 GMT

Hi Aiolos,

Thanks for your comment

Lets consider only task2 and task3 from the table in my first message. Lets assume they have been completed 10/01/2018 at 11:30

Task	TaskStartDate	TaskEndDate
task2	09/01/2018 12:20	10/01/2018 11:30
task3	06/01/2018 06:00	10/01/2018 17:30

So the table for the chart will be like below:

[0/1 means 1 task has been assigned, but not done, therefore performance is 0%)

X-axis shows each day, Y-axis performance

Day	Person1	Person2	Person3
06/01/2018	0/1 0%	0/1 0%	0/1 0%
07/01/2018	0/1 0%	0/1 0%	0/1 0%
08/01/2018	0/1 0%	0/1 0%	0/1 0%
09/01/2018	0/1 0%	0/2 0%	0/2 0%
10/01/2018	0/2 0%	1/2 50%	1/1 100%

The main issue which I have is how to make the uncompleted task will be 'moving" until is done

Hope this shows better what I would like to make in qlikview

Thank in advance

Re: Bar Chart with accomplished tasks

Anonymous — Sun, 14 Jan 2018 14:12:45 GMT

Hello,

Has anybody any idea how to solve this? Thanks

Re: Bar Chart with accomplished tasks

uacg0009 — Mon, 15 Jan 2018 05:51:52 GMT

Hi Krzysztof,

Well, it really takes me some times to do that, but it's interesting.

Hope that's what you want.

Thanks

Aiolos

Re: Bar Chart with accomplished tasks

Anonymous — Mon, 15 Jan 2018 12:33:17 GMT

Thank you Aiolos, this is exactly what I was expecting and it works perfectly

Really appreciated your help

Thanks,

Krzysztof

Re: Bar Chart with accomplished tasks

uacg0009 — Tue, 16 Jan 2018 01:12:44 GMT

You are welcome. It's also glad to help you.

Aiolos