topic Re: How to built a report table depending on whether two periods overlap? in QlikView https://community.qlik.com/t5/QlikView/How-to-built-a-report-table-depending-on-whether-two-periods/m-p/462425#M486586 <HTML><HEAD></HEAD><BODY><P>You can use the intervalmatch function to match the dates to the periods. See attached qvw.</P></BODY></HTML> Fri, 22 Feb 2013 10:50:09 GMT Gysbert_Wassenaar 2013-02-22T10:50:09Z How to built a report table depending on whether two periods overlap? https://community.qlik.com/t5/QlikView/How-to-built-a-report-table-depending-on-whether-two-periods/m-p/462424#M486585 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hi,</P><P></P><P style="text-align: left;">I need to rebuilt a small reporting table from two small input tables based upon some rules.</P><P style="text-align: left;"><SPAN style="font-size: 10pt;">One of the rules is that rows of the reported table depend on whether the requested timeperiod (a field in the report table) overlaps with a different time period defined in one of the input tables.</SPAN></P><P style="text-align: left;"><SPAN style="font-size: 10pt;">The problem is explained in more detail in the attached Qvw.</SPAN></P><P></P><P style="text-align: left;"><SPAN style="font-size: 10pt;">Background: I'm basically trying to reconstruct a table that comes as an output of a BO system.</SPAN></P><P style="text-align: left;">P.S.: Any suggestions how to better formulate the problem?</P><P style="text-align: left;">Thx for your input.</P><P></P><P style="text-align: left;">_Koen</P></BODY></HTML> Fri, 22 Feb 2013 10:06:32 GMT https://community.qlik.com/t5/QlikView/How-to-built-a-report-table-depending-on-whether-two-periods/m-p/462424#M486585 cheburashka 2013-02-22T10:06:32Z Re: How to built a report table depending on whether two periods overlap? https://community.qlik.com/t5/QlikView/How-to-built-a-report-table-depending-on-whether-two-periods/m-p/462425#M486586 <HTML><HEAD></HEAD><BODY><P>You can use the intervalmatch function to match the dates to the periods. See attached qvw.</P></BODY></HTML> Fri, 22 Feb 2013 10:50:09 GMT https://community.qlik.com/t5/QlikView/How-to-built-a-report-table-depending-on-whether-two-periods/m-p/462425#M486586 Gysbert_Wassenaar 2013-02-22T10:50:09Z