topic Re: Creating a common calender for two dates in QlikView https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619961#M228276 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date">http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date</A></P></BODY></HTML> Wed, 09 Apr 2014 12:52:39 GMT MK_QSL 2014-04-09T12:52:39Z Creating a common calender for two dates https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619960#M228275 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; I have two fact tables Order and Quotes. I have two dates for each fact table (Order date and Quotes date). I have a requirement where in i have to create a bar chart for no.of Orders and no.of Quotes&nbsp; with quarter as dimension. Since i have two different Quarters(Order Qtr and Quotes Qtr) i am not able to show correct values in the chart.</P><P>I want to use a quarter dimension which is common to both the fact tables. Is there any way to create a common calender for both dates(Orders date and Quotes date)?</P></BODY></HTML> Wed, 09 Apr 2014 12:48:37 GMT https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619960#M228275 farheenayesha 2014-04-09T12:48:37Z Re: Creating a common calender for two dates https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619961#M228276 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date">http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date</A></P></BODY></HTML> Wed, 09 Apr 2014 12:52:39 GMT https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619961#M228276 MK_QSL 2014-04-09T12:52:39Z Re: Creating a common calender for two dates https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619962#M228277 <HTML><HEAD></HEAD><BODY><P>Thanks Manish. This is what i was looking for..</P></BODY></HTML> Wed, 09 Apr 2014 13:01:50 GMT https://community.qlik.com/t5/QlikView/Creating-a-common-calender-for-two-dates/m-p/619962#M228277 farheenayesha 2014-04-09T13:01:50Z