topic Re: Comparison data of dates in QlikView https://community.qlik.com/t5/QlikView/Comparison-data-of-dates/m-p/498909#M186391 <HTML><HEAD></HEAD><BODY><P>You can use the intervalmatch function to match the division date intervals with the quota dates. See this blog post: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch" style="font-size: 12px; color: #252525;">IntervalMatch</A>. If you want to break things down to weeks and days you probably want a master calendar. See this tutorial: <A _jive_internal="true" href="https://community.qlik.com/thread/66717" style="font-size: 12px; color: #007fc0; font-family: Arial;">Tutorial - Using Common Date Dimensions and Shared Calendars</A></P></BODY></HTML> Fri, 19 Jul 2013 06:25:56 GMT Gysbert_Wassenaar 2013-07-19T06:25:56Z Comparison data of dates https://community.qlik.com/t5/QlikView/Comparison-data-of-dates/m-p/498908#M186390 <HTML><HEAD></HEAD><BODY><P>Hi all. I need help.</P><P></P><P>My problem is:</P><P>- Understand a logic to compare dates of quotas and dates of divisions lifecycle.</P><P>So</P><P>I have a table of plans(quota) for divisions on quarters:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>division</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Date</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>Quota</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">200000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">400000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">550000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">700000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">700000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">850000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1500000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">190000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">380000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">525000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">665000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">665000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">808000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">190000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">380000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">525000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">665000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">665000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">808000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">220000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">440000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">605000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">770000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">770000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">935000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1650000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">350000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">450000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">580000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">630000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">775000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">805000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1250000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1500000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1600000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">330000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">550000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">600000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">665000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">735000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">765000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1175000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2007</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1520000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">330000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">550000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">600000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">665000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">735000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1175000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1520000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">385000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">495000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">638000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">693000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">770000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">853000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1375000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1650000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1750000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">286</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">450000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">450000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">660000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">667000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">725000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">725000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">850000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1400000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1400000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1850000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2750000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">286</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">627000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">635000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">680000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">685000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">800000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1330000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1330000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1750000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.10.2008</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">3450000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">286</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">425000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">627000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">635000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">680000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">685000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">800000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1330000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1330000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1750000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">4300000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">286</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">495000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">495000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">726000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">735000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">795000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">795000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">935000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1540000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1540000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">2035000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.04.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5375000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">286</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">470000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">470000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">693000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">700000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">725000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">760000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">890000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1470000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1470000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">1940000</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">Website</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2009</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">5900000</SPAN></TD></TR></TBODY></TABLE><P></P><P>and information about divisions:</P><P></P><TABLE bgcolor="#ffffff" border="1" cellpadding="2" cellspacing="0" style="font-size: 9pt;"><TBODY><TR bgcolor="#f5f5f5"><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>division</STRONG></SPAN></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>StartDate</STRONG></SPAN><STRONG> </STRONG></TH><TH nowrap="nowrap"><SPAN style="color: #363636;"><STRONG>EndDate</STRONG></SPAN><STRONG> </STRONG></TH></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">30.06.2007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">280</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">31.10.2007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">31.12.2007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">31.12.2007</SPAN> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">276</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">279</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2006</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">282</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">289</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">290</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2007</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">284</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.11.2007</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">275</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">277</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.01.2008</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">286</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"> </TD></TR><TR bgcolor="#ffffff"><TD bgcolor="#ffffff"><SPAN style="color: #363636;">288</SPAN> </TD><TD bgcolor="#ffffff"><SPAN style="color: #363636;">01.07.2008</SPAN> </TD><TD bgcolor="#ffffff"><BR /></TD></TR></TBODY></TABLE><P></P><P>And i need calculate SALES vs QUOTA. I have no any idea how to do that. </P><P>But looking into date we've got quota for divisions by quarters. </P><P>So i'm looking for the <STRONG>righ way to join two tables</STRONG>! and <STRONG>to break quarters on months on weeks on days for division managers</STRONG>... </P><P>Thnx. Any ideas?</P></BODY></HTML> Fri, 19 Jul 2013 06:06:35 GMT https://community.qlik.com/t5/QlikView/Comparison-data-of-dates/m-p/498908#M186390 lylererger 2013-07-19T06:06:35Z Re: Comparison data of dates https://community.qlik.com/t5/QlikView/Comparison-data-of-dates/m-p/498909#M186391 <HTML><HEAD></HEAD><BODY><P>You can use the intervalmatch function to match the division date intervals with the quota dates. See this blog post: <A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/04/intervalmatch" style="font-size: 12px; color: #252525;">IntervalMatch</A>. If you want to break things down to weeks and days you probably want a master calendar. See this tutorial: <A _jive_internal="true" href="https://community.qlik.com/thread/66717" style="font-size: 12px; color: #007fc0; font-family: Arial;">Tutorial - Using Common Date Dimensions and Shared Calendars</A></P></BODY></HTML> Fri, 19 Jul 2013 06:25:56 GMT https://community.qlik.com/t5/QlikView/Comparison-data-of-dates/m-p/498909#M186391 Gysbert_Wassenaar 2013-07-19T06:25:56Z