topic Re: Interval Match and Duplicate Values in QlikView https://community.qlik.com/t5/QlikView/Interval-Match-and-Duplicate-Values/m-p/352106#M130624 <HTML><HEAD></HEAD><BODY><P>Just add a DISTINCT command... Like below..</P><P></P><P><EM>AUTOGENERATE $(vMaxDate) - $(vMinDate) +1;</EM></P><P></P><P><EM>FullTable:</EM></P><P><EM>JOIN (Data) INTERVALMATCH (Date) LOAD <STRONG>DISTINCT </STRONG>DateStart, DateEnd</EM></P><P><EM>RESIDENT Data;</EM></P><P></P><P><EM>DROP TABLE Calendar;</EM></P></BODY></HTML> Wed, 26 Sep 2012 15:15:25 GMT 2012-09-26T15:15:25Z Interval Match and Duplicate Values https://community.qlik.com/t5/QlikView/Interval-Match-and-Duplicate-Values/m-p/352105#M130623 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to use the interval match and it is generating duplicate values.</P><P></P><P>While loading the script it is showing as 21 rows and if you see the preview in the Ctrl+T it is showing 31 rows... Attached theQVW file and screenshot for your reference.</P></BODY></HTML> Thu, 14 Jun 2012 00:51:15 GMT https://community.qlik.com/t5/QlikView/Interval-Match-and-Duplicate-Values/m-p/352105#M130623 brindlogcool 2012-06-14T00:51:15Z Re: Interval Match and Duplicate Values https://community.qlik.com/t5/QlikView/Interval-Match-and-Duplicate-Values/m-p/352106#M130624 <HTML><HEAD></HEAD><BODY><P>Just add a DISTINCT command... Like below..</P><P></P><P><EM>AUTOGENERATE $(vMaxDate) - $(vMinDate) +1;</EM></P><P></P><P><EM>FullTable:</EM></P><P><EM>JOIN (Data) INTERVALMATCH (Date) LOAD <STRONG>DISTINCT </STRONG>DateStart, DateEnd</EM></P><P><EM>RESIDENT Data;</EM></P><P></P><P><EM>DROP TABLE Calendar;</EM></P></BODY></HTML> Wed, 26 Sep 2012 15:15:25 GMT https://community.qlik.com/t5/QlikView/Interval-Match-and-Duplicate-Values/m-p/352106#M130624 2012-09-26T15:15:25Z