Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik Community,
I would like to visualize the orders that are currently at a workstation. After the completion at every station the worker confirms in SAP and hands the order to the next workstation.
My database is a table where lines are added with each confirmation, including information about order number, product type, workstation, date and time of confirmation.
How do I code that into ie. a bar chart?
Basic (every order has same flow through workplaces):
For one workstation it should show all those orders, whos last confirmation entry is of the station before.
confirmation number | date | time | order number | product type | workstation |
3788345 | 2020/11/03 | 10:00 | 34 | A | cutting |
3788346 | 2020/11/03 | 10:30 | 35 | B | cutting |
3788347 | 2020/11/03 | 11:00 | 34 | A | spraying |
3788348 | 2020/11/03 | 14:00 | 34 | A | drying |
3788349 | 2020/11/04 | 06:00 | 35 | B | spraying |
3788350 | 2020/11/04 | 8:00 | 35 | B | drying |
3788351 | 2020/11/04 | 13:00 | 36 | C | cutting |
3788352 | 2020/11/05 | 9:00 | 34 | A | packaging |
3788353 | 2020/11/06 | 10:00 | 36 | C | spraying |
3788354 | 2020/11/06 | 12:00 | 36 | C | drying |
I would like to visualize it like this (+ maybe the bars stacked by the product type laying at the station):
Complex (different flow through workplaces):
As the products vary so does the order of the workplaces needed to produce it. Therefore there are several workplaces that orders can come from to get to the workplace in question.
confirmation number | date | time | order number | product type | workstation |
3788345 | 2020/11/03 | 10:00 | 34 | A | cutting |
3788346 | 2020/11/03 | 10:30 | 35 | B | cutting |
3788347 | 2020/11/03 | 11:00 | 34 | A | spraying |
3788348 | 2020/11/03 | 14:00 | 34 | A | drying |
3788349 | 2020/11/04 | 8:00 | 35 | B | packaging |
3788350 | 2020/11/04 | 13:00 | 36 | C | mixing |
3788351 | 2020/11/05 | 9:00 | 34 | A | packaging |
3788352 | 2020/11/06 | 10:00 | 36 | C | drying |
3788353 | 2020/11/06 | 12:00 | 36 | C | cutting |
I assume I should set up a table similar to this:
Product type | production order | workstation |
A | 1 | cutting |
A | 2 | spraying |
A | 3 | drying |
A | 4 | packaging |
B | 1 | cutting |
B | 2 | packaging |
C | 1 | mixing |
C | 2 | drying |
C | 3 | cutting |
How would I connect this to the idea before? Or is there a more clever way than a new table?
Kind regards
Lena