topic Re: Please create a perfect datamodel for the below data in QlikView https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124917#M463786 <HTML><HEAD></HEAD><BODY><P>your model is empty</P></BODY></HTML> Fri, 03 Jun 2016 19:34:48 GMT Clever_Anjos 2016-06-03T19:34:48Z Please create a perfect datamodel for the below data https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124916#M463785 <HTML><HEAD></HEAD><BODY><P>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&nbsp; 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</P></BODY></HTML> Fri, 03 Jun 2016 17:42:05 GMT https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124916#M463785 2016-06-03T17:42:05Z Re: Please create a perfect datamodel for the below data https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124917#M463786 <HTML><HEAD></HEAD><BODY><P>your model is empty</P></BODY></HTML> Fri, 03 Jun 2016 19:34:48 GMT https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124917#M463786 Clever_Anjos 2016-06-03T19:34:48Z Re: Please create a perfect datamodel for the below data https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124918#M463787 <HTML><HEAD></HEAD><BODY><P>Hi Mahesh</P><P></P><P>your data model is empty.i think forgot to reload the application . reload it and upload the doc..again</P></BODY></HTML> Fri, 03 Jun 2016 20:10:10 GMT https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124918#M463787 2016-06-03T20:10:10Z Re: Please create a perfect datamodel for the below data https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124919#M463788 <HTML><HEAD></HEAD><BODY><P>Hi Mahesh,</P><P></P><P>To avoid <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">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.</SPAN></P><P></P><P>Refer to this blog for discussion about Link Tables:&nbsp; <A href="https://community.qlik.com/qlik-blogpost/3119">Concatenate vs Link Table</A></P><P></P><P>Hope this helps,</P><P>Carlos</P></BODY></HTML> Sun, 05 Jun 2016 17:21:19 GMT https://community.qlik.com/t5/QlikView/Please-create-a-perfect-datamodel-for-the-below-data/m-p/1124919#M463788 clondono 2016-06-05T17:21:19Z