Need help to normalize tables.

[#1]

I need help to normalize the tables to avoid cycle in the data model.

I have following tables

Invoice header : invoice date , invoice type, store id

invoice lines : item id, line amount

Master Item : item id, description, product cat, product brand

Inventory : Store id, item id, Qty

now it creating the cycle as invoice header also has store id and inventory also has got item id. Please help how to avoid and de-normalize it. Thanks.

[marcus_sommer]

Within qlikview it's not necessary to normalize the datamodel, see here how you could easily build datamodels: Get started with developing qlik datamodels.

- Marcus

[#3]

What I meant i have a circular reference in my above example, where in invoice header, i have store id m where it sold, item details in master table and then I have table where on hand qty for item is available. so it creates circular reference between invoice head, master item and store table.

Need your expert help to get rid of it.

[marcus_sommer]

In a first step I would join or map the field "line amount" from the table "invoice lines" to the table "Master Item".

- Marcus