Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Please create a perfect datamodel for the below data

Hi i have a 3 dimension tables and 2 fact tables which was converted in to qvds and loaded to create a perfect model .Can any one  Please create a perfect data model without any association and synthetic keys for the below given data and please explain the script, Thank you in advance

3 Replies
Employee
Employee

Re: Please create a perfect datamodel for the below data

your model is empty

Not applicable

Re: Please create a perfect datamodel for the below data

Hi Mahesh

your data model is empty.i think forgot to reload the application . reload it and upload the doc..again

clondono
Contributor III

Re: Please create a perfect datamodel for the below data

Hi Mahesh,

To avoid synthetic keys in your data model you can create a Link table to avoid circular references and to join the two fact tables in your model.

Refer to this blog for discussion about Link Tables:  Concatenate vs Link Table

Hope this helps,

Carlos

Community Browser