Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

krzftyri
New Contributor

Bar Chart with accomplished tasks

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:

TaskTaskStartDateTaskEndDate
task122/12/2017 16:3023/12/2017 11:00
task209/01/2018 12:20null
task306/01/2018  06:00null
task412/12/2017 15:0013/12/2017 14:00
task514/12/2017 9:0015/12/2017 6:00
task603/12/2017 14:006/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

1 Solution

Accepted Solutions
uacg0009
Valued Contributor

Re: Bar Chart with accomplished tasks

Hi Krzysztof,

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

Hope that's what you want.

Bar Chart with accomplished tasks.PNG

Thanks

Aiolos

6 Replies
uacg0009
Valued Contributor

Re: Bar Chart with accomplished tasks

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

krzftyri
New Contributor

Re: Bar Chart with accomplished tasks

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

TaskTaskStartDateTaskEndDate
task209/01/2018 12:2010/01/2018 11:30
task306/01/2018  06:0010/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

DayPerson1Person2Person3
06/01/20180/1 0%0/1 0%0/1 0%
07/01/20180/1 0%0/1 0%0/1 0%
08/01/20180/1 0%0/1 0%0/1 0%
09/01/20180/1 0%0/2 0%0/2 0%
10/01/20180/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

krzftyri
New Contributor

Re: Bar Chart with accomplished tasks

Hello,

Has anybody any idea how to solve this? Thanks

uacg0009
Valued Contributor

Re: Bar Chart with accomplished tasks

Hi Krzysztof,

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

Hope that's what you want.

Bar Chart with accomplished tasks.PNG

Thanks

Aiolos

krzftyri
New Contributor

Re: Bar Chart with accomplished tasks

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

Really appreciated your help

Thanks,

Krzysztof

uacg0009
Valued Contributor

Re: Bar Chart with accomplished tasks

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

Aiolos

Community Browser