topic Logical problem in QlikView https://community.qlik.com/t5/QlikView/Logical-problem/m-p/645980#M236798 <HTML><HEAD></HEAD><BODY><P>I have a complicated problem.</P><P></P><P>The example is about trash collection routes, they each have a name.</P><P>I want to know how many addresses and how many products (trash containers) each route contains.</P><P></P><P>A product (trashcontainer) has a dotation id (meaning: green trash, paper, large, small)</P><P></P><P>In the word attachment you can see the relations of this problem in the database.</P><P></P><P>The number of addresses on a route is: count(distinct card_id)</P><P>The number of containers on a route is: count(product_id)</P><P></P><P>I wil attach the word doc, a sample qvw document.</P><P></P><P>I'll give you the qvd files if you guys need them.</P><P></P><P>I hope someone can help me!</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Fri, 08 Aug 2014 10:23:47 GMT 2014-08-08T10:23:47Z Logical problem https://community.qlik.com/t5/QlikView/Logical-problem/m-p/645980#M236798 <HTML><HEAD></HEAD><BODY><P>I have a complicated problem.</P><P></P><P>The example is about trash collection routes, they each have a name.</P><P>I want to know how many addresses and how many products (trash containers) each route contains.</P><P></P><P>A product (trashcontainer) has a dotation id (meaning: green trash, paper, large, small)</P><P></P><P>In the word attachment you can see the relations of this problem in the database.</P><P></P><P>The number of addresses on a route is: count(distinct card_id)</P><P>The number of containers on a route is: count(product_id)</P><P></P><P>I wil attach the word doc, a sample qvw document.</P><P></P><P>I'll give you the qvd files if you guys need them.</P><P></P><P>I hope someone can help me!</P><P></P><P>Kind regards,</P><P>Katleen</P></BODY></HTML> Fri, 08 Aug 2014 10:23:47 GMT https://community.qlik.com/t5/QlikView/Logical-problem/m-p/645980#M236798 2014-08-08T10:23:47Z Re: Logical problem https://community.qlik.com/t5/QlikView/Logical-problem/m-p/645981#M236799 <HTML><HEAD></HEAD><BODY><P>Hi. </P><P></P><P>You have to break the loop reference.</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references">http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references</A></P></BODY></HTML> Sat, 09 Aug 2014 06:48:47 GMT https://community.qlik.com/t5/QlikView/Logical-problem/m-p/645981#M236799 whiteline 2014-08-09T06:48:47Z