topic Need help to normalize tables. in QlikView

Need help to normalize tables.

Mon, 03 Aug 2015 16:11:49 GMT

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.

Re: Need help to normalize tables.

marcus_sommer — Mon, 03 Aug 2015 16:17:37 GMT

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

Re: Need help to normalize tables.

Mon, 03 Aug 2015 16:24:13 GMT

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.

Re: Need help to normalize tables.

marcus_sommer — Tue, 04 Aug 2015 08:21:57 GMT

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

- Marcus