topic Modelling issue in QlikView

Modelling issue

Thu, 28 May 2009 22:14:06 GMT

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.

Modelling issue

Thu, 28 May 2009 22:23:00 GMT

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...

Modelling issue

Thu, 28 May 2009 22:24:28 GMT

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?

Modelling issue

Fri, 29 May 2009 02:15:02 GMT

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

Modelling issue

Fri, 29 May 2009 02:31:55 GMT

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.

Modelling issue

Fri, 29 May 2009 14:59:49 GMT

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.

Modelling issue

Tue, 02 Jun 2009 20:50:52 GMT

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