topic question about intervalmatch in QlikView https://community.qlik.com/t5/QlikView/question-about-intervalmatch/m-p/230621#M82433 <HTML><HEAD></HEAD><BODY><P>Intervals:<BR />REPLACE LOAD * INLINE [<BR /> StartValue, EndValue, Buckets</P><P>20090101-20090131, 200901</P><P>20090201-20090230, 200902</P><P>.......<BR /><BR />];<BR /><BR />// INTERVALMATCH_TABLE<BR /><BR />intervalmatch (Date_Value)<BR />Load StartValue,EndValue resident Intervals;<BR /><BR />intervalmatch (Date)<BR />Load StartValue,EndValue resident Intervals;</P><P>i have this intervalmatch, which gives me a [Bucket] Field.</P><P>i get this message after loading: one or more loops have been detected in your database. loops may cause ambiguous results and should therefore be avoided. Qlikview will cut the loops by setting one or more tables as loosely coupled. Settings for looseley coupled tables can be modified after the script execution in the tables page of the document properties dialog.</P><P></P><P></P><P></P><P></P></BODY></HTML> Wed, 04 Nov 2009 03:33:56 GMT amien 2009-11-04T03:33:56Z question about intervalmatch https://community.qlik.com/t5/QlikView/question-about-intervalmatch/m-p/230621#M82433 <HTML><HEAD></HEAD><BODY><P>Intervals:<BR />REPLACE LOAD * INLINE [<BR /> StartValue, EndValue, Buckets</P><P>20090101-20090131, 200901</P><P>20090201-20090230, 200902</P><P>.......<BR /><BR />];<BR /><BR />// INTERVALMATCH_TABLE<BR /><BR />intervalmatch (Date_Value)<BR />Load StartValue,EndValue resident Intervals;<BR /><BR />intervalmatch (Date)<BR />Load StartValue,EndValue resident Intervals;</P><P>i have this intervalmatch, which gives me a [Bucket] Field.</P><P>i get this message after loading: one or more loops have been detected in your database. loops may cause ambiguous results and should therefore be avoided. Qlikview will cut the loops by setting one or more tables as loosely coupled. Settings for looseley coupled tables can be modified after the script execution in the tables page of the document properties dialog.</P><P></P><P></P><P></P><P></P></BODY></HTML> Wed, 04 Nov 2009 03:33:56 GMT https://community.qlik.com/t5/QlikView/question-about-intervalmatch/m-p/230621#M82433 amien 2009-11-04T03:33:56Z