Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Model

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.

6 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

Hi ask123 ,

This will definitely give you some idea .

Please go through attached doc .

Cheers,

Bhushan N

Not applicable
Author

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,

Not applicable
Author

Hi ASK123 ,

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

Cheers,

Bhushan N

Not applicable
Author

Hi ASK123 ,

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

Cheers,

Bhushan N

Not applicable
Author

Hi Bhushan,

Thanks for the solusion, it is working.

Best regards.