topic Match interval in unlinked tables in QlikView https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465316#M173775 <HTML><HEAD></HEAD><BODY><P>Hello all!</P><P></P><P>I have a bench of meeting rooms reservation logs on one side (start time, end time).</P><P>I would like to know, for each time slot contained in an excel file, how many meeting rooms are booked.</P><P>I tried several solutions, but no idea how to go further.</P><P>I attached the log file, interval excel and qvw.</P><P></P><P>Thanks for your ideas.</P><P>Hub</P></BODY></HTML> Wed, 12 Jun 2013 09:51:53 GMT 2013-06-12T09:51:53Z Match interval in unlinked tables https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465316#M173775 <HTML><HEAD></HEAD><BODY><P>Hello all!</P><P></P><P>I have a bench of meeting rooms reservation logs on one side (start time, end time).</P><P>I would like to know, for each time slot contained in an excel file, how many meeting rooms are booked.</P><P>I tried several solutions, but no idea how to go further.</P><P>I attached the log file, interval excel and qvw.</P><P></P><P>Thanks for your ideas.</P><P>Hub</P></BODY></HTML> Wed, 12 Jun 2013 09:51:53 GMT https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465316#M173775 2013-06-12T09:51:53Z Re: Match interval in unlinked tables https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465317#M173776 <HTML><HEAD></HEAD><BODY><P>Have you tried the interval match script command ?</P><P>Jonathan</P></BODY></HTML> Wed, 12 Jun 2013 09:56:26 GMT https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465317#M173776 Anonymous 2013-06-12T09:56:26Z Re: Match interval in unlinked tables https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465318#M173777 <HTML><HEAD></HEAD><BODY><P>See the attached my application</P><P>hope it helps you </P></BODY></HTML> Wed, 12 Jun 2013 10:05:39 GMT https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465318#M173777 er_mohit 2013-06-12T10:05:39Z Re: Match interval in unlinked tables https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465319#M173778 <HTML><HEAD></HEAD><BODY><P>Thank you both for your comment!</P><P>It really helped!</P><P>I had to put the time slots in the start_end time of booking interval, which I figured out after spending 2 hours trying to do the things in the opposite way <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Once again, great! it works ! Thanks!</P></BODY></HTML> Wed, 12 Jun 2013 12:16:46 GMT https://community.qlik.com/t5/QlikView/Match-interval-in-unlinked-tables/m-p/465319#M173778 2013-06-12T12:16:46Z