topic Re: Production Line Data Model in QlikView

Production Line Data Model

oehmemat — Thu, 31 Oct 2019 21:56:09 GMT

Hello Community,

I would like to calculate the amount of wares (and costs, duration later on) needed for a production / manufacturing line.

The data contains 'recipes' with the ingredients and the amount needed, the output of the recipe and the duration.

The recipes can be chained to 7 levels maximum and are loaded via hierarchy load into a table which contains all the needed information.

I am struggling with displaying and calculating the data properly, e.g. there is a need to calculate if the output of one recipe fills the demand of the recipe coming next or if the first recipe need multiple runs. And sometimes wares needed to be 'sidechained' into the production line.

The formulas are not a problem, but I am not sure if my understanding of this is right and if my data model fits to this.

Maybe someone has an advice for me or an example?

The data and the qlikview document is attached.

Cheers Matthias

Re: Production Line Data Model

Brett_Bleess — Thu, 07 Nov 2019 19:42:58 GMT

Matthias, the best I have is the following Design Blog link:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

Here is the base URL for the Design Blog area too in case you want to do some further searching yourself:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Found one other specific one that might be helpful too:

https://community.qlik.com/t5/Qlik-Design-Blog/Bill-of-Materials/ba-p/1462792

Hopefully this helps you move things forward.

Regards,
Brett

Re: Production Line Data Model

oehmemat — Fri, 08 Nov 2019 08:43:14 GMT

Hello Brett,

thank you for your Reply.

I was able to manage it with using a Hierarchy load regarding the Input/Output Commodities to generate a RecipePath. After that I broke up the Path in it's steps and joined the Commodities again to finally calulate the sums and difference of the needed Wares per Recipe Path regarding how many times the recipe has to run during the Recipe Path.

Cheers Matthias