Associative model question

[#1]

Hello,

The more I use Qlikview, the more I'm unsure about what to do sometimes...

I have an application with a sales order table and a sales invoice table, which I concatenated into a fact table like this:

Sales Order	Sales Invoice	Order Value	Invoice Value	Origin
AAA		100		ORDERS
AAA	1234		100	INVOICES

Of course, there are dimension tables attached to the fact table.

Now, I was asked to make a report where I show the invoice value per order reason. I already have this field is in the order table, and not on the invoice table.

Can I make this with my current model, or should I change it and have a fact table like this, where I retrieve the order reason and put it into my fact table?:

Sales Order	Sales Invoice	Order Value	Invoice Value	Origin	OrderReason
AAA		100		ORDERS	F11
AAA	1234		100	INVOICES	F11

Thanks

[#2]

I'm sorry that it took me so long to answer, but I think I did not understand your suggestion, because what I understood would create a loop.

Let's say that you have two tables: orders and invoices, with the following fields

-     Orders

• OrderDate
• OrderNumber
• OrderValue

-     Invoices

• InvoiceDate
• InvoiceNumber
• OrderNumber
• InvoiceValue

How would you link them in your example so that I can show the Sum(OrderValue) and the Sum(InvoiceValue) on the same day?