Hi ask123 ,
This will definitely give you some idea .
Please go through attached doc .
Data_Model.qvw 119.2 K
Thanks for the reply.
I have created the table but result are not correct, If I concatenate Sales and Inventory table then results are correct but I include the Item again results are not correct, Pl. help me how can I include the Item table also.
The Qlikview file is containing the data is attached along with.
Sales.qvw 124.0 K
I have follwoing two fact table and one dimension table.
Sales: InvoiceNo,Invoicedate,item code,item qty,Sales Amount,cost
Invnetory: item code, Qty on Hand, Inventory Value
Item: Item Code, Item desc, Product group, Product Sub group
How can I create data model in QV for above data.