topic link 2 filed in a document in QlikView

link 2 filed in a document

gidon500 — Sat, 07 Apr 2012 06:44:33 GMT

Hi due to circular problem , i hab set 2 filed for customer number one for invoices( CUSTINVNO) and one for orders( CUSTORDNO) , in same sheet i need to have 2 objects , one to evalute orders and other to evalute invoices , when i select to the filed CUSTINVNO with certain value i want that the filed CUSTORDNO wil perform the same selection , ( like if they were same filed ) is it possible ? , many thanks for your help gidon

link 2 filed in a document

Jason_Michaelides — Sat, 07 Apr 2012 06:50:11 GMT

Circular references usually occur when you have more than one fact table that both link to the same dimension and also have a common field themselves. The best way to avoid this is to join the fact tables together using Concatenate(). In your case, try:

Customers:

LOAD

CUSTNO,

Field2,

Field3,

etc

FROM Customers...;

Fact:

LOAD

'Order' AS FactType,

CUSTNO,

Field2,

Field3,

OrderDate AS Date,

etc

FROM Orders...;

CONCATENATE (Fact)

LOAD

'Invoice' AS FactType,

CUSTNO,

Field2,

Field3,

InvoiceDate AS Date,

etc

FROM Invoices...;

Now you only have one fact table but can separate the types with FactType. CUSTNO is now the same field.

Hope this helps,

Jason

link 2 filed in a document

gidon500 — Sat, 07 Apr 2012 07:19:52 GMT

Hi Jason , i will try it , so what you say is that i will have one table , that will include both Invoices data and orders data , will this increase the size on my model , as each line the the new table will have lots of empty cells thanks for your fast and professional gidon

link 2 filed in a document

Jason_Michaelides — Sat, 07 Apr 2012 07:33:03 GMT

That's right. It will actually most likely reduce the size of the data model. QlilView stores DISTINCT values of each field just once, no matter what tables they are in. This way you only have one field CUSTNO, not 2. Empty fields won't matter.