# Building a productivity Dashboard...

**Dario Orbecchi**Mar 16, 2016 3:03 PM

Hello, I'm trying to build a simple dashboard to monitor the Productivity of my team and I need some help...

I have two Excel tables:

1) WorkingHours contains the number of daily working hours of my employees

2) Production contains the number of items produced by each employee, each day.

To compute the hourly productivity, I need to sum the number of items produced by an employee (they work on different product types) and divide it by the number of hours worked in a given day.

I've already built a prototype in Excel and with a couple of pivot tables it is quite easy to achieve a result similar to this:

Employee Productivity (Items/hour) | 15/12/2015 | 16/12/2015 | 17/12/2015 | 18/12/2015 | Total |

A | 1,63 | 2,13 | 1,50 | 0,38 | 1,41 |

B | 0,38 | 2,83 | 1,50 | 0,56 | 1,19 |

C | 1,50 | 2,00 | 2,47 | 2,25 | 2,04 |

Now... how can I achieve the same result in QlikView?

This is the WorkingHours table:

Employee | Date | WorkingHours |

A | 15/12/2015 | 8 |

B | 15/12/2015 | 8 |

C | 15/12/2015 | 8 |

A | 16/12/2015 | 8 |

B | 16/12/2015 | 6 |

C | 16/12/2015 | 7 |

A | 17/12/2015 | 8 |

B | 17/12/2015 | 8 |

C | 17/12/2015 | 8,5 |

A | 18/12/2015 | 8 |

B | 18/12/2015 | 9 |

C | 18/12/2015 | 4 |

And this is the Production table:

Employee | Date | Products | ItemsProduced |

A | 15/12/2015 | X | 1 |

A | 15/12/2015 | Y | 8 |

A | 15/12/2015 | Z | 2 |

A | 16/12/2015 | X | 12 |

A | 16/12/2015 | Z | 5 |

A | 15/12/2015 | Z | 2 |

A | 17/12/2015 | X | 4 |

A | 17/12/2015 | Y | 5 |

A | 17/12/2015 | Z | 3 |

A | 18/12/2015 | Z | 3 |

B | 15/12/2015 | X | 3 |

B | 16/12/2015 | X | 12 |

B | 16/12/2015 | Z | 5 |

B | 17/12/2015 | X | 7 |

B | 17/12/2015 | Z | 5 |

B | 18/12/2015 | Z | 5 |

C | 15/12/2015 | X | 2 |

C | 15/12/2015 | Y | 3 |

C | 15/12/2015 | Z | 4 |

C | 16/12/2015 | X | 6 |

C | 16/12/2015 | Z | 8 |

C | 15/12/2015 | Z | 3 |

C | 17/12/2015 | X | 5 |

C | 17/12/2015 | Y | 7 |

C | 17/12/2015 | Z | 9 |

C | 18/12/2015 | Z | 9 |

Should I use a join when loading the tables in QlikView?

I'm not sure, since in the Production table I need to sum the number of products produced each day. Is there a way to build a total in the Load script?

Or would it be better to load both tables separately in QV and then aggregate them?

This is my first post in the QV Community... thank you in advance for any help!

Dario