Logical problem

[#1]

I have a complicated problem.

The example is about trash collection routes, they each have a name.

I want to know how many addresses and how many products (trash containers) each route contains.

A product (trashcontainer) has a dotation id (meaning: green trash, paper, large, small)

In the word attachment you can see the relations of this problem in the database.

The number of addresses on a route is: count(distinct card_id)

The number of containers on a route is: count(product_id)

I wil attach the word doc, a sample qvw document.

I'll give you the qvd files if you guys need them.

I hope someone can help me!

Kind regards,

Katleen

[whiteline]

Hi.

You have to break the loop reference.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/25/circular-references