topic Re: count based on start and end date in QlikView https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626296#M1092997 <HTML><HEAD></HEAD><BODY><P>Maybe master calendar and intervalmatch in load script?</P><P>Or calenadar as an island table ....</P></BODY></HTML> Fri, 23 May 2014 12:29:10 GMT 2014-05-23T12:29:10Z count based on start and end date https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626294#M1092995 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>I want to count the occupancy(ie 'Booking' field) for each week.</P><P>My table has From and ToDate of each booking.</P><P></P><P>I am not sure how to count the bookings falling between start and end date of the week?</P></BODY></HTML> Fri, 23 May 2014 12:18:20 GMT https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626294#M1092995 surajap123 2014-05-23T12:18:20Z Re: count based on start and end date https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626295#M1092996 <HTML><HEAD></HEAD><BODY><P>Hi Suraj</P><P></P><P>use the function InWeek</P><P>it gives true if the date is in the week</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Fri, 23 May 2014 12:28:04 GMT https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626295#M1092996 2014-05-23T12:28:04Z Re: count based on start and end date https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626296#M1092997 <HTML><HEAD></HEAD><BODY><P>Maybe master calendar and intervalmatch in load script?</P><P>Or calenadar as an island table ....</P></BODY></HTML> Fri, 23 May 2014 12:29:10 GMT https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626296#M1092997 2014-05-23T12:29:10Z Re: count based on start and end date https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626297#M1092998 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I suggest you have to use any master calendar for this and then check the expected date for the given ranges.</P><P></P><P>Regards</P></BODY></HTML> Fri, 23 May 2014 12:47:09 GMT https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626297#M1092998 its_anandrjs 2014-05-23T12:47:09Z Re: count based on start and end date https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626298#M1092999 <HTML><HEAD></HEAD><BODY><P>Thanks everyone for the suggestions. I have build the master calender, but still not getting the right count of 13 for RoomID 1065.</P><P></P><P>Infact i want to get the BookingID count per week.</P><P></P><P>I am not sure how i can add interval match to the script., i am attaching the modified app and source data. !</P></BODY></HTML> Fri, 23 May 2014 13:17:12 GMT https://community.qlik.com/t5/QlikView/count-based-on-start-and-end-date/m-p/626298#M1092999 surajap123 2014-05-23T13:17:12Z