Data Model

[#1]

Hi,

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.

Thanks.

[Anonymous]

You just need to load these items in the script ... with the [item code] these tables shall be connected to eachother ...

Create a script and load the data ... the items with the same name shall be interpreted as key ...

[#3]

Hi ask123 ,

This will definitely give you some idea .

Please go through attached doc .

Cheers,

Bhushan N

[#4]

Hi Bhushan,

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.

Best Regards,

[#5]

Hi ASK123 ,

You need to reload your applicaion (as i can't able to do it from here) & check later on .

Cheers,

Bhushan N

[#6]

Hi ASK123 ,

Reload this one (latest) . Previous may give you some error.

Cheers,

Bhushan N

[#7]

Hi Bhushan,

Thanks for the solusion, it is working.

Best regards.