Many to Many relationship table issue

Tue, 03 Nov 2015 15:00:07 GMT

Hi Guys,

I am facing an issue with a many to many relation table.

So, here is my table:

Invoice_Id	Check_Id	Supplier Id
1001	1111	1
1002	1111	1
1003	1112	3
1004	1113	4
1004	1114	4

As, you can see in the above payments table there is a many to many relation between invoice_id and check_id.

There are below three tables and a fact table already loaded.

1. Invoices table: there are many columns in this one, below are two main

AutoNumber (Invoice_Id & supplier_id) as key_id,

Invoice_Id

2. Checks table: there are many columns in this one, below are two main

AutoNumber (Check_Id & supplier_id) as key_id,

Check_Id

3. Supplier table

Supplier Id,

Supplier Name.

4. Facts table: this also has many columns but the main ones are

AutoNumber (SourceId & supplier_id) as key_id, please sourceid column contains both invoice and check id's (they differ as per the type of transaction)

Supplier Id

Now, the issue is the model works fine if I just user 1-4 tables, but as soon as I add the payments table, it goes into a loop and error's out.

I want that when I click on a check, then i should be able to see the invoices for that check and vice a versa for a supplier.

Hope this makes sense. Please help me with this, any help will be greatly appreciated.

Please let me know if you have any more questions.

Thank you

topic Many to Many relationship table issue in QlikView

Many to Many relationship table issue