topic Production Planning in QlikView https://community.qlik.com/t5/QlikView/Production-Planning/m-p/400351#M148949 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to create 2 tables. first one shows, inventory, quantity in order, transfer quantites and so on (about 8 different tables).</P><P>the second table shows exactly the same for the components according to the manufacturing specification of the selected item in the first table. </P><P>my problem is, that in each table is always one item field. there is no flag if it is an component or something else. secondly an item can sometimes also be a component. does anybody know how to solve this problem? load all tables twice or is there any better way?</P><P></P><P>Thank you.</P><P></P><P>Br,</P><P>Michael</P></BODY></HTML> Mon, 04 Feb 2013 15:26:02 GMT michael_maeuser 2013-02-04T15:26:02Z Production Planning https://community.qlik.com/t5/QlikView/Production-Planning/m-p/400351#M148949 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to create 2 tables. first one shows, inventory, quantity in order, transfer quantites and so on (about 8 different tables).</P><P>the second table shows exactly the same for the components according to the manufacturing specification of the selected item in the first table. </P><P>my problem is, that in each table is always one item field. there is no flag if it is an component or something else. secondly an item can sometimes also be a component. does anybody know how to solve this problem? load all tables twice or is there any better way?</P><P></P><P>Thank you.</P><P></P><P>Br,</P><P>Michael</P></BODY></HTML> Mon, 04 Feb 2013 15:26:02 GMT https://community.qlik.com/t5/QlikView/Production-Planning/m-p/400351#M148949 michael_maeuser 2013-02-04T15:26:02Z Re: Production Planning https://community.qlik.com/t5/QlikView/Production-Planning/m-p/400352#M148950 <HTML><HEAD></HEAD><BODY><P>The post is quite old but still can be useful for someone. </P><P></P><P>In my specific case i created a hierarchy based on the bill of material to solve the problem you mentioned. </P></BODY></HTML> Tue, 26 Nov 2013 10:45:43 GMT https://community.qlik.com/t5/QlikView/Production-Planning/m-p/400352#M148950 2013-11-26T10:45:43Z