topic Issue in Calculating Interval for Timestamp in QlikView https://community.qlik.com/t5/QlikView/Issue-in-Calculating-Interval-for-Timestamp/m-p/982434#M335275 <HTML><HEAD></HEAD><BODY><P>Hi Qlik Guys,</P><P></P><P>Greetings...!!!</P><P></P><P>I have 3 Tables listed below and their respective linking.</P><P></P><P>1. Sales</P><P>2. Project</P><P>3. IVR</P><P></P><P>Sales and Project linked with ID, Sales and IVR linked with ID &amp; Date &amp; CLI_No.</P><P></P><P>I have Created_Time in Sales Table and Start_Time, End_Time in IVR Table. I want to check in which Interval of Start_Time and End_time does my Create_Time lies. Also, What if there is One to Many Relation in Sales&lt;=&gt; IVR table.</P><P></P><P>I have already implemented IntervalMatch() but unable to get the desired Result.<SPAN style="font-size: 13.3333px;">Kindly assist.</SPAN></P><P></P><P>Thanks &amp; Regards</P><P>Sumeet</P></BODY></HTML> Thu, 24 Dec 2015 10:15:36 GMT sumeet-vaidya 2015-12-24T10:15:36Z Issue in Calculating Interval for Timestamp https://community.qlik.com/t5/QlikView/Issue-in-Calculating-Interval-for-Timestamp/m-p/982434#M335275 <HTML><HEAD></HEAD><BODY><P>Hi Qlik Guys,</P><P></P><P>Greetings...!!!</P><P></P><P>I have 3 Tables listed below and their respective linking.</P><P></P><P>1. Sales</P><P>2. Project</P><P>3. IVR</P><P></P><P>Sales and Project linked with ID, Sales and IVR linked with ID &amp; Date &amp; CLI_No.</P><P></P><P>I have Created_Time in Sales Table and Start_Time, End_Time in IVR Table. I want to check in which Interval of Start_Time and End_time does my Create_Time lies. Also, What if there is One to Many Relation in Sales&lt;=&gt; IVR table.</P><P></P><P>I have already implemented IntervalMatch() but unable to get the desired Result.<SPAN style="font-size: 13.3333px;">Kindly assist.</SPAN></P><P></P><P>Thanks &amp; Regards</P><P>Sumeet</P></BODY></HTML> Thu, 24 Dec 2015 10:15:36 GMT https://community.qlik.com/t5/QlikView/Issue-in-Calculating-Interval-for-Timestamp/m-p/982434#M335275 sumeet-vaidya 2015-12-24T10:15:36Z Re: Issue in Calculating Interval for Timestamp https://community.qlik.com/t5/QlikView/Issue-in-Calculating-Interval-for-Timestamp/m-p/982435#M335276 <HTML><HEAD></HEAD><BODY><P>Would be best if you could upload a small sample QVW that can be reloaded (so either use some INLINE tables with sample data or some Excel tables attached), and also attach your requested result (e.g. as another excel table).</P></BODY></HTML> Thu, 24 Dec 2015 11:51:28 GMT https://community.qlik.com/t5/QlikView/Issue-in-Calculating-Interval-for-Timestamp/m-p/982435#M335276 swuehl 2015-12-24T11:51:28Z