Modelling issue

[#1]

Hi,

I'm currently dealing with a modelling issue. I have these tables:

Customer
=========
customer_id
...


Sales_head
===========
customer_id
sales_head_id
....


Sales_main
===========
sales_head_id
article_id
sales_amount
...


Bid_head
=========
customer_id
bid_head_id
...


Bid_main
=========
bid_head_id
article_id
bid_amount
....


Articles
=========
article_id
article_kpi
.....


I'd like to create a chart(table) where I can see article_kpi, sales_amount, bid_amount.
The main problem is that the articles aren't connected either to bid_main or sales_main.
How can I solve this issue?
Thanks in advance.

[#2]

Hi Elzo,

If Bid_main, Sales_main and Articles have the article_id field, the tree tables are connected, right ?

Remember that QV use the name of the fields to make the connection between data...

[#3]

It looks like you have the article_id in both the Bid_main and Sales_main tables. If you load all of those tables in, QlikView should associate the article_ids and you should have no problem creating the chart you described.

Have you loaded these into QlikView? Have you checked the Table Viewer to make sure those article_id fields are linked?

[#4]

I'm getting circular reference error because I article is connected to bid_main and sales_main.

[#5]

That's odd, I've never experienced that error before. Could you attach a sample?

You could try using aliases in your load:

Sales_main
article_id as article_sales_id

Bid_main
article_id as article_bid_id

Articles
article_id as article_sales_id,
article_id as article_bid_id

That will load separate fields to link to each table. I don't think that should be necessary, but it's worth a try.

[#6]

Hi,

I attached an example. Is there a way to get the articles directly connected to the customers? Would this solve my problem.
To the table customers several other tables are connected.

[#7]

I'm not sure about the logics behind you data, but this is an example of how you could use join and concatenate to avoid a circular reference in this case.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.56.95/cr_5F00_problem.qvw]

BR,

Ida