topic How to match the interval and count in QlikView https://community.qlik.com/t5/QlikView/How-to-match-the-interval-and-count/m-p/285357#M106110 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have calendar date.</P><P></P><P>AP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp; Start date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end date</P><P>AP01&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp; 2-Jan-12&nbsp; 1-Feb-12</P><P>AP02&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp; 2-Feb-12&nbsp; 28-Feb-12</P><P>.</P><P>.</P><P>Now i have an column induction date plan is&nbsp; as 5-Jan-12</P><P></P><P>now all the records in induction date has to check the calendar start and end date and it show count as 1 for AP01.</P><P></P><P></P><P>which columns should i link.. should i use interval match.. if so how ?? or in expression is it simple ??</P></BODY></HTML> Wed, 15 Feb 2012 15:16:16 GMT 2012-02-15T15:16:16Z How to match the interval and count https://community.qlik.com/t5/QlikView/How-to-match-the-interval-and-count/m-p/285357#M106110 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>I have calendar date.</P><P></P><P>AP&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year&nbsp;&nbsp; Start date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end date</P><P>AP01&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp; 2-Jan-12&nbsp; 1-Feb-12</P><P>AP02&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp;&nbsp; 2-Feb-12&nbsp; 28-Feb-12</P><P>.</P><P>.</P><P>Now i have an column induction date plan is&nbsp; as 5-Jan-12</P><P></P><P>now all the records in induction date has to check the calendar start and end date and it show count as 1 for AP01.</P><P></P><P></P><P>which columns should i link.. should i use interval match.. if so how ?? or in expression is it simple ??</P></BODY></HTML> Wed, 15 Feb 2012 15:16:16 GMT https://community.qlik.com/t5/QlikView/How-to-match-the-interval-and-count/m-p/285357#M106110 2012-02-15T15:16:16Z