topic Re: Calendar to Facts in QlikView https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456857#M170585 <HTML><HEAD></HEAD><BODY><P>Here it will create circular key, As key column name is same in all the three tables</P></BODY></HTML> Fri, 26 Oct 2012 07:42:49 GMT 2012-10-26T07:42:49Z Calendar to Facts https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456855#M170583 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I have two fact table. In both the tables I have transaction dates. When I am joining tranasaction tables to Calendar Object, I am getting circular key.</P><P></P><P></P><P>How can I remove this ?</P><P></P><P>Kindly help.</P><P></P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-274463-24252/demo.bmp"><IMG __jive_id="24253" alt="demo.bmp" class="jive-image jiveImage" height="353" src="https://community.qlik.com/servlet/JiveServlet/downloadImage/2-274483-24253/demo.bmp" width="432" /></A></P><P>Here I want to remove the lnk between two the two fact(Sales and Target). These two table should be joined to Calendar table.</P></BODY></HTML> Fri, 26 Oct 2012 07:25:26 GMT https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456855#M170583 2012-10-26T07:25:26Z Re: Calendar to Facts https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456856#M170584 <HTML><HEAD></HEAD><BODY><P>calendar:</P><P>LOAD</P><P>Fiscal_Year &amp; Fiscal_Month as Fiscal_YM,</P><P>Fiscal_Year,</P><P>Fiscal_Month</P><P>...........................</P><P>Target:</P><P>Fiscal_Year &amp; Fiscal Month as Fiscal_YM,</P><P>Fiscal_Year as Fiscal_Year_Target,</P><P>Fiscal _Month as Fiscal_Month_Target</P><P>..............................</P><P>Sales:</P><P>Fiscal_Year &amp; Fiscal_Month as Fiscal_YM,</P><P>Fiscal_Year as Fiscal_Year_Sales,</P><P>Fiscal _Month as Fiscal_Month_Sales</P><P></P><P>Trie with this..</P><P>Hope it help you</P></BODY></HTML> Fri, 26 Oct 2012 07:38:16 GMT https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456856#M170584 fdelacal 2012-10-26T07:38:16Z Re: Calendar to Facts https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456857#M170585 <HTML><HEAD></HEAD><BODY><P>Here it will create circular key, As key column name is same in all the three tables</P></BODY></HTML> Fri, 26 Oct 2012 07:42:49 GMT https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456857#M170585 2012-10-26T07:42:49Z Re: Calendar to Facts https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456858#M170586 <HTML><HEAD></HEAD><BODY><P>It isn´t a circular.</P><P>LOOK Atach qvw.</P><P>If you don´t like this solution another way is create a new <SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">intermediate table with all date.. and you can unit the other tables with this.</SPAN></SPAN></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">look another qvw, qq<BR /></SPAN></SPAN></P></BODY></HTML> Fri, 26 Oct 2012 08:21:42 GMT https://community.qlik.com/t5/QlikView/Calendar-to-Facts/m-p/456858#M170586 fdelacal 2012-10-26T08:21:42Z