Associations betwenne three qvd

[alessandro]

Hi to all.

I'm new of this forum and I have a question for you.

I have three qvd: one for the Contracts (with inside fields like "Business", "ContractCode", "Name", "Address", "Value", "ProductCode", etc), one for the Product (with inside fields like "Business", "ProductCode" and "ProductSales") and at the end one for Cover (with inside fields like "Business", "ContractCode" and "ProductCode").

I done this associations: Contracts with Cover throught "Business" and "ContractCode" and then the association betwenne Cover with Product throught "Business" and "ProductCode" to take "ProductSales").

I built some reports and is all right. But if I want  to know the value for ProductSales I have all ProductSales with the same value. I think that I wrong the associations.

Is there someone that give me a advise?

Thanks for all.

ciao

ale

[martinpohl]

normally you get a message about a circular reference

QlikView is linking tables where the field name is equal.

so contracts and product are linke by the field Business and productcode

and the table Cover is linked to contracts by fields business and contractcode and to table products by business and productcode.

What information are in table cover? I can't see additional fields

[qliksus]

What's the dimension you are taking ?? this scenario happens when the join is not made on the proper granular level between tables  

[martinpohl]

in a circular refernce the joins are broken and are visible by a ------ line

[alessandro]

Hi, sorry for delay to reply you.

I think that I don't have circular reference (it doesn't seem to me that there is written or it's visible).

I attached a small scheme of the associations.

Like you see, perhaps, the matter is because the associations is not perfetct. In fact the colour is non green but orange.

I tried, also, to build an manually associations...but, I don't know why, the circle remains in the center but I think it is not complete.

I do other tests.

[qliksus]

You should take ProductCode as dimension and Productsales as metrics . Why are you using Productsales as dimension ?

[alessandro]

Because ProductSales are the categories (groups)  of many codes (ProductCode). While as metrics I use value

[Brett_Bleess]

Here are some Design Blog references that will likely be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Here is the main Design Blog link in case you want to search further yourself:

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

Regards,
Brett

[alessandro · Accepted solution]

Hello to all,

and thanks so much.

I read the articles and I solved.

I modified the fields, taking the field 'value' not in the main table but in the table 'ProductSales'.

Please let me know if and where I need to enter some information to close this thread.

Thanks again.

ciao

ale