Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
In a first step I would join or map the field "line amount" from the table "invoice lines" to the table "Master Item".
- Marcus