topic Re: Intervalmatch problem in QlikView https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387729#M695553 <HTML><HEAD></HEAD><BODY><P>Hard to say. If you could post another example -- without dropping the tables -- I'll take a look.</P><P></P><P>-Rob</P></BODY></HTML> Thu, 23 May 2013 23:53:25 GMT rwunderlich 2013-05-23T23:53:25Z Intervalmatch problem https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387726#M695550 <HTML><HEAD></HEAD><BODY><P>Hello All!</P><P>I have a problem with intervalmatch. I just cant get it to work. I think I have a problem with the Time-field but I dont know how to change it.</P><P></P><P>Im attaching my testfile.</P><P></P><P>I hope someone out there can give me som suggestions how to change my code.</P><P></P><P>Thank you!</P><P></P><P>Br</P><P>cris</P></BODY></HTML> Mon, 20 May 2013 15:42:14 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387726#M695550 mr_novice 2013-05-20T15:42:14Z Re: Intervalmatch problem https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387727#M695551 <HTML><HEAD></HEAD><BODY><P>You'll need to extract the time portion from the timestamp by using frac(). </P><P></P><P>time(frac(DelDate),'hh:mm') as Time</P><P></P><P>The time() functiom only formats the display value, it does not extract the time only. </P><P></P><P>-Rob</P></BODY></HTML> Mon, 20 May 2013 19:17:04 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387727#M695551 rwunderlich 2013-05-20T19:17:04Z Re: Intervalmatch problem https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387728#M695552 <HTML><HEAD></HEAD><BODY><P>Thank you Rob!</P><P></P><P>You solved my problem. I didnt think about that. Now there's another problem. I dont get a match with all intervals even though a match should be done. I have a match to only only one row in the 'interval table'. Could it still be a time-format problem?</P><P></P><P>Br</P><P>cristian</P></BODY></HTML> Wed, 22 May 2013 08:06:11 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387728#M695552 mr_novice 2013-05-22T08:06:11Z Re: Intervalmatch problem https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387729#M695553 <HTML><HEAD></HEAD><BODY><P>Hard to say. If you could post another example -- without dropping the tables -- I'll take a look.</P><P></P><P>-Rob</P></BODY></HTML> Thu, 23 May 2013 23:53:25 GMT https://community.qlik.com/t5/QlikView/Intervalmatch-problem/m-p/387729#M695553 rwunderlich 2013-05-23T23:53:25Z