topic Re: Circular Reference or Loops in QlikView https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504295#M188469 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply Thomas,...</P><P>1) do we need to have first qualify necessary for Customer and Country table?</P><P>2) when I create Straight Table with Customer, Year as dimension and SUM(Sales) and SUM(TARGET.Target) gives me wrong result.</P></BODY></HTML> Thu, 19 Dec 2013 11:14:15 GMT MK_QSL 2013-12-19T11:14:15Z Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504284#M188458 <HTML><HEAD></HEAD><BODY><P>Hello Experts...</P><P>In enclosed QlikView files, there is a circular reference/loops.</P><P>Is there any way to remove the same. Does it make any damage in end result if not removed?</P></BODY></HTML> Thu, 19 Dec 2013 09:27:33 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504284#M188458 MK_QSL 2013-12-19T09:27:33Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504285#M188459 <HTML><HEAD></HEAD><BODY><P><STRONG>Manish</STRONG></P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Circular reference/loops will most likely cause issues &amp; confusion.</SPAN></P><P></P><P>Have you tried concatenating the TARGET and SALES tables to sort it.</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Thu, 19 Dec 2013 09:32:53 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504285#M188459 Anonymous 2013-12-19T09:32:53Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504286#M188460 <HTML><HEAD></HEAD><BODY><P>Hi Manish</P><P></P><P>Yes you have to choose which key you want for Invoice (InvoiceDate or InvoiceYear)</P><P></P><P>I understand you need both but I would suggest you create a table with</P><P>Customer &amp; InvoiceYear&nbsp;&nbsp;&nbsp;&nbsp; as %CY, </P><P>Customer &amp; InvoiceDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as %CD,</P><P>Customer,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as %C</P><P>InvoiceYear&nbsp; as %Y</P><P>InvoiceDate as %D</P><P>from Sales </P><P></P><P>and rearrange your key in other tables</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Thu, 19 Dec 2013 09:36:02 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504286#M188460 2013-12-19T09:36:02Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504287#M188461 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>You can join Sales and Target table usign a composite key as below.</P><P></P><P>check the attached QVW.</P><P></P><P>Regards,</P><P>Shruthi</P></BODY></HTML> Thu, 19 Dec 2013 09:41:20 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504287#M188461 2013-12-19T09:41:20Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504288#M188462 <HTML><HEAD></HEAD><BODY><P>Shruthi, this is giving me some strange result.</P></BODY></HTML> Thu, 19 Dec 2013 10:02:31 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504288#M188462 MK_QSL 2013-12-19T10:02:31Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504289#M188463 <HTML><HEAD></HEAD><BODY><P>Can you explain what d you mean by Strange.I could not reload as I dont have the source files.</P></BODY></HTML> Thu, 19 Dec 2013 10:07:40 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504289#M188463 2013-12-19T10:07:40Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504290#M188464 <HTML><HEAD></HEAD><BODY><P>Source file is also enclosed....</P></BODY></HTML> Thu, 19 Dec 2013 10:10:13 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504290#M188464 MK_QSL 2013-12-19T10:10:13Z Re: Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504291#M188465 <HTML><HEAD></HEAD><BODY><P>Hi Manish,</P><P></P><P>see the attached QVW. This will simply solve circular reference and also gives the desired output.</P></BODY></HTML> Thu, 19 Dec 2013 10:25:40 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504291#M188465 2013-12-19T10:25:40Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504292#M188466 <HTML><HEAD></HEAD><BODY><P>need to compare Sales and Target year wise....</P></BODY></HTML> Thu, 19 Dec 2013 10:35:26 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504292#M188466 MK_QSL 2013-12-19T10:35:26Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504293#M188467 <HTML><HEAD></HEAD><BODY><P>Try this:</P></BODY></HTML> Thu, 19 Dec 2013 10:44:10 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504293#M188467 2013-12-19T10:44:10Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504294#M188468 <HTML><HEAD></HEAD><BODY><P>Compare Sales and Target tables,Concatenate both tables...</P></BODY></HTML> Thu, 19 Dec 2013 10:47:48 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504294#M188468 2013-12-19T10:47:48Z Re: Circular Reference or Loops https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504295#M188469 <HTML><HEAD></HEAD><BODY><P>Thanks for your reply Thomas,...</P><P>1) do we need to have first qualify necessary for Customer and Country table?</P><P>2) when I create Straight Table with Customer, Year as dimension and SUM(Sales) and SUM(TARGET.Target) gives me wrong result.</P></BODY></HTML> Thu, 19 Dec 2013 11:14:15 GMT https://community.qlik.com/t5/QlikView/Circular-Reference-or-Loops/m-p/504295#M188469 MK_QSL 2013-12-19T11:14:15Z