Problem in Data Modelling

deepakk — Tue, 09 Feb 2010 10:25:12 GMT

Hi ,

I am facing a data model problem.

I have two Tables Product Master and Product SalesData.

Product Master contains ProductID, Sales Rep Name and Date. Here the date indicates date on which the product has been created.

ProductSalesData contains ProductId,Date and SalesAmt. Here the date indicates transaction date.

I need to created two reports. New Product Report and Product Sales Report.

I am linking the ProductMaster and ProductSalesData with ProductID and Year,Month and Day of the dates in both the table.

But I am not getting SalesRepName correctly due to this linking. Please look into the attachment and let me know if you can help me out.

Deepak

Tue, 09 Feb 2010 13:03:18 GMT

Hi Deepak,

Here you are a possible solution.

I hope it helps you.

Best regards.

topic Problem in Data Modelling in QlikView