topic Re: Time Match Interval Duplication in QlikView https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576400#M214447 <HTML><HEAD></HEAD><BODY><P>Hi Aamir,</P><P></P><P>I'm facing the same problem if anyone have idea please share.</P></BODY></HTML> Thu, 27 Feb 2014 07:23:30 GMT 2014-02-27T07:23:30Z Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576399#M214446 <HTML><HEAD></HEAD><BODY><P>I am trying to get Zone and Percentage for a specific Device and time. That is I am matching Interval Device and Time with Time Interval to get its Zone and Percentage. The Device can be connected to multiple devices with percentage allocated. But it is working fine with single row but as soon as there are x-squared lines to one interval there is x duplication of lines in end result. For example I have made 3 Zones for a specific interval so there are 9 lines instead of 3 lines.</P><P></P><P>Can anyone help to eliminate the extra rows or alternate solution</P></BODY></HTML> Thu, 27 Feb 2014 05:31:46 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576399#M214446 2014-02-27T05:31:46Z Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576400#M214447 <HTML><HEAD></HEAD><BODY><P>Hi Aamir,</P><P></P><P>I'm facing the same problem if anyone have idea please share.</P></BODY></HTML> Thu, 27 Feb 2014 07:23:30 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576400#M214447 2014-02-27T07:23:30Z Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576401#M214448 <HTML><HEAD></HEAD><BODY><P>Adeel</P><P><A href="https://community.qlik.com/qlik-users/15823">swuehl</A></P><P><A href="https://community.qlik.com/qlik-users/96544">Gysbert Wassenaar</A></P><P></P><P></P><P>Guys please reply</P></BODY></HTML> Thu, 27 Feb 2014 08:37:45 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576401#M214448 2014-02-27T08:37:45Z Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576402#M214449 <HTML><HEAD></HEAD><BODY><P>Load <STRONG>distinct</STRONG></P></BODY></HTML> Fri, 28 Feb 2014 21:29:49 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576402#M214449 whiteline 2014-02-28T21:29:49Z Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576403#M214450 <HTML><HEAD></HEAD><BODY><P>where should i use distinct. I mean in which load as I can't use it interval match</P></BODY></HTML> Sun, 02 Mar 2014 10:32:47 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576403#M214450 2014-03-02T10:32:47Z Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576404#M214451 <HTML><HEAD></HEAD><BODY><P>You have to prepare the table before using interval match.</P><P>Create temporary table with load distinct.</P></BODY></HTML> Sun, 02 Mar 2014 12:44:36 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576404#M214451 whiteline 2014-03-02T12:44:36Z Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576405#M214452 <HTML><HEAD></HEAD><BODY><P>Can you do this in my QVW because i don't think that's right solution as multiple lines are required in temp table of Interval match</P></BODY></HTML> Sun, 02 Mar 2014 16:06:21 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576405#M214452 2014-03-02T16:06:21Z Re: Re: Time Match Interval Duplication https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576406#M214453 <HTML><HEAD></HEAD><BODY><P>Aamir,</P><P></P><P>Please find attached file hope this will help</P></BODY></HTML> Mon, 03 Mar 2014 06:25:24 GMT https://community.qlik.com/t5/QlikView/Time-Match-Interval-Duplication/m-p/576406#M214453 2014-03-03T06:25:24Z