topic data model relationships in QlikView https://community.qlik.com/t5/QlikView/data-model-relationships/m-p/944241#M959949 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Our Fact table linked to multiple dimension tables. Few dimension tables are futher linked to another dimension table.</P><P>To investigate the issues in the data model i want to find the following-</P><P></P><P>1. How to find whether linking between fact and dimension table is one-to-one or one-many or many-to-many.</P><P></P><P>2. How to find if there is granularity issue between fact and dimension table?</P><P></P><P>Please let me know ways to investigate this.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Thu, 22 Oct 2015 10:52:37 GMT surajap123 2015-10-22T10:52:37Z data model relationships https://community.qlik.com/t5/QlikView/data-model-relationships/m-p/944241#M959949 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Our Fact table linked to multiple dimension tables. Few dimension tables are futher linked to another dimension table.</P><P>To investigate the issues in the data model i want to find the following-</P><P></P><P>1. How to find whether linking between fact and dimension table is one-to-one or one-many or many-to-many.</P><P></P><P>2. How to find if there is granularity issue between fact and dimension table?</P><P></P><P>Please let me know ways to investigate this.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Thu, 22 Oct 2015 10:52:37 GMT https://community.qlik.com/t5/QlikView/data-model-relationships/m-p/944241#M959949 surajap123 2015-10-22T10:52:37Z Re: data model relationships https://community.qlik.com/t5/QlikView/data-model-relationships/m-p/944242#M959950 <HTML><HEAD></HEAD><BODY><P>You can create tables with a field from one table and a count of a field from another associated table. If you find counts larger than one then you have a one-to-many relationship. If you then do the same the other way around you can check if the one-to-many is actually a many-to-many relationship.</P></BODY></HTML> Thu, 22 Oct 2015 11:16:02 GMT https://community.qlik.com/t5/QlikView/data-model-relationships/m-p/944242#M959950 Gysbert_Wassenaar 2015-10-22T11:16:02Z