topic Re: Loops problem... in QlikView https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168539#M39652 <HTML><HEAD></HEAD><BODY><P>As mentioned in the earlier reply, please find the attached file which contain joined Order and Order_spec table.</P></BODY></HTML> Wed, 07 Mar 2012 12:47:09 GMT 2012-03-07T12:47:09Z Loops problem... https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168537#M39650 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to create simple report of orders/stock of items, but I have problem with "loops"... Anyone could help me?</P><P></P><P>I attach screen of the loops and sample file that recreates the problem...</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-656_sourceID:656" /></P><P>BR</P><P>Borys</P></BODY></HTML> Sun, 29 Nov 2009 17:05:11 GMT https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168537#M39650 boryspower 2009-11-29T17:05:11Z Loops problem... https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168538#M39651 <HTML><HEAD></HEAD><BODY><P>You need to join the tables Order and Order_spec. For instance ...</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Order:<BR />LOAD * FROM Order;<BR />Order_spec:<BR />LOAD * FROM Order_spec;<BR />JOIN (Orders) LOAD * RESIDENT Order_spec;<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>The tables will be joined on field order_id.</P></BODY></HTML> Sun, 29 Nov 2009 20:34:00 GMT https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168538#M39651 2009-11-29T20:34:00Z Re: Loops problem... https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168539#M39652 <HTML><HEAD></HEAD><BODY><P>As mentioned in the earlier reply, please find the attached file which contain joined Order and Order_spec table.</P></BODY></HTML> Wed, 07 Mar 2012 12:47:09 GMT https://community.qlik.com/t5/QlikView/Loops-problem/m-p/168539#M39652 2012-03-07T12:47:09Z