topic Data Model in QlikView

Data Model

Wed, 06 Jan 2010 12:06:34 GMT

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.

Data Model

Anonymous — Wed, 06 Jan 2010 12:11:42 GMT

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 ...

Data Model

Wed, 06 Jan 2010 13:51:29 GMT

Hi ask123 ,

This will definitely give you some idea .

Please go through attached doc .

Cheers,

Bhushan N

Data Model

Thu, 07 Jan 2010 12:58:04 GMT

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,

Data Model

Thu, 07 Jan 2010 13:37:12 GMT

Hi ASK123 ,

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

Cheers,

Bhushan N

Data Model

Thu, 07 Jan 2010 14:10:12 GMT

Hi ASK123 ,

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

Cheers,

Bhushan N

Data Model

Mon, 11 Jan 2010 09:01:28 GMT

Hi Bhushan,

Thanks for the solusion, it is working.

Best regards.