topic Matching Interval With Interval in QlikView https://community.qlik.com/t5/QlikView/Matching-Interval-With-Interval/m-p/464179#M173356 <HTML><HEAD></HEAD><BODY><P>I'm trying to match two date ranges and then count the number of days that overlap from one to another. Both intervals reside in a same table. For example, I'm trying to calculate number of DaysDiscounted:</P><P></P><P>FromActualDate&nbsp;&nbsp;&nbsp;&nbsp; ToActualDate&nbsp;&nbsp;&nbsp;&nbsp; FromDiscountDate&nbsp;&nbsp;&nbsp;&nbsp; ToDiscountDate&nbsp;&nbsp;&nbsp;&nbsp; DaysDiscounted</P><P></P><P>3/24/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/6/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 </P><P>4/7/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/20/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>3/24/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/6/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/5/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P></P><P>I could implenet manual logic something like a calculated field like:</P><P></P><P>=if(ToDiscountDate &gt; ToActualDate, (ToDiscountDate - ToActualDate)+1,(ToActualDate - FromDiscountDate)+1)</P><P></P><P>but it does not work in all Cases, wondering if QlikView provides more effiecient way, similar to IntervalMatch.</P><P></P><P>Any suggestions?</P></BODY></HTML> Wed, 17 Apr 2013 16:39:37 GMT Anonymous 2013-04-17T16:39:37Z Matching Interval With Interval https://community.qlik.com/t5/QlikView/Matching-Interval-With-Interval/m-p/464179#M173356 <HTML><HEAD></HEAD><BODY><P>I'm trying to match two date ranges and then count the number of days that overlap from one to another. Both intervals reside in a same table. For example, I'm trying to calculate number of DaysDiscounted:</P><P></P><P>FromActualDate&nbsp;&nbsp;&nbsp;&nbsp; ToActualDate&nbsp;&nbsp;&nbsp;&nbsp; FromDiscountDate&nbsp;&nbsp;&nbsp;&nbsp; ToDiscountDate&nbsp;&nbsp;&nbsp;&nbsp; DaysDiscounted</P><P></P><P>3/24/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/6/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 </P><P>4/7/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/20/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>3/24/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/6/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/1/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/5/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P></P><P>I could implenet manual logic something like a calculated field like:</P><P></P><P>=if(ToDiscountDate &gt; ToActualDate, (ToDiscountDate - ToActualDate)+1,(ToActualDate - FromDiscountDate)+1)</P><P></P><P>but it does not work in all Cases, wondering if QlikView provides more effiecient way, similar to IntervalMatch.</P><P></P><P>Any suggestions?</P></BODY></HTML> Wed, 17 Apr 2013 16:39:37 GMT https://community.qlik.com/t5/QlikView/Matching-Interval-With-Interval/m-p/464179#M173356 Anonymous 2013-04-17T16:39:37Z