topic Re: Problem with Circular References in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880357#M470444 <HTML><HEAD></HEAD><BODY><P>These are the tables that I have in the database</P><P><IMG alt="QV_duda.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86842_QV_duda.jpg" style="height: 293px; width: 620px;" /></P></BODY></HTML> Mon, 18 May 2015 20:23:11 GMT stvn_003 2015-05-18T20:23:11Z Problem with Circular References https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880354#M470441 <HTML><HEAD></HEAD><BODY><P>Hello, I have a problem with circular references does anyone have an idea or suggestion for it?</P><P><IMG alt="DERQV.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86824_DERQV.jpg" style="height: 322px; width: 620px;" /></P></BODY></HTML> Mon, 18 May 2015 15:42:45 GMT https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880354#M470441 stvn_003 2015-05-18T15:42:45Z Re: Problem with Circular References https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880355#M470442 <HTML><HEAD></HEAD><BODY><P>You should rethink your data model. There should be only one path from a table to any other table. A Star schema is ideal, limited snowflaking isn't a problem. You also have to consider the synthetic keys. They point out problems with your data model. Try to get rid of them. Perhaps you need a link table with all the key fields and create new key fields to link the tables with the link table. Perhaps this blog post helps explain this concept: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">Concatenate vs Link Table</A></P></BODY></HTML> Mon, 18 May 2015 15:56:31 GMT https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880355#M470442 Gysbert_Wassenaar 2015-05-18T15:56:31Z Re: Problem with Circular References https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880356#M470443 <HTML><HEAD></HEAD><BODY><P>So the relationship that should create the link tables table?</P></BODY></HTML> Mon, 18 May 2015 17:20:46 GMT https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880356#M470443 stvn_003 2015-05-18T17:20:46Z Re: Problem with Circular References https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880357#M470444 <HTML><HEAD></HEAD><BODY><P>These are the tables that I have in the database</P><P><IMG alt="QV_duda.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/86842_QV_duda.jpg" style="height: 293px; width: 620px;" /></P></BODY></HTML> Mon, 18 May 2015 20:23:11 GMT https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880357#M470444 stvn_003 2015-05-18T20:23:11Z Re: Problem with Circular References https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880358#M470445 <HTML><HEAD></HEAD><BODY><P>I think I'd get rid of the CustomerProduct table. In your first screenshot there seems to be only one field p_sku_cliente in that table besides the key fields. If you don't use this field for any analysis thenyou don't need the CustomerProduct table. If you do need it for analysis you can probably use a mapping table and the applymap function to add it to the PurchaseOrderDetail table.</P></BODY></HTML> Tue, 19 May 2015 07:47:51 GMT https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880358#M470445 Gysbert_Wassenaar 2015-05-19T07:47:51Z Re: Problem with Circular References https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880359#M470446 <HTML><HEAD></HEAD><BODY><P>The<EM> Purchase Order Header</EM> and the<EM> Purchase Order Detail</EM> tables could be combined into a single <EM>Fact</EM> table to be the centre of a <STRONG style="font-size: 13.3333330154419px;">Star Schema</STRONG>.</P><P></P><P>The <EM>Customer</EM> and <EM>Customer Group</EM> <SPAN style="font-size: 13.3333330154419px;">tables </SPAN>could also be combined into a single <EM>Dimension</EM> Table.</P><P></P><P>As Gysbert suggested you could ignore the <EM>Customer Product</EM> table, so the <EM>Product</EM> table becomes another <EM>Dimension</EM> table.</P><P></P><P>Thus leaving a simple <STRONG>Star Schema</STRONG> with one <EM>Fact</EM> table and 2 <EM>Dimension</EM> tables.</P></BODY></HTML> Tue, 19 May 2015 07:57:08 GMT https://community.qlik.com/t5/QlikView/Problem-with-Circular-References/m-p/880359#M470446 Anonymous 2015-05-19T07:57:08Z