topic Re: Dynamic interval in QlikView https://community.qlik.com/t5/QlikView/Dynamic-interval/m-p/404953#M568695 <HTML><HEAD></HEAD><BODY><P>anyone??</P></BODY></HTML> Wed, 07 Nov 2012 12:38:38 GMT xtrimf 2012-11-07T12:38:38Z Dynamic interval https://community.qlik.com/t5/QlikView/Dynamic-interval/m-p/404952#M568694 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P style="text-align: left;">I have the following table:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="356"><TBODY><TR style="height: 15.0pt;"><TD align="left" height="20" style="height: 15.0pt; width: 48pt;" width="64">Phone1</TD><TD align="left" style="width: 48pt;" width="64">Phone2</TD><TD align="left" style="width: 67pt;" width="89">Call direction</TD><TD align="left" style="width: 56pt;" width="75">date</TD><TD align="left" style="width: 48pt;" width="64">time</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">789</TD><TD class="xl67">OUT</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:00</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">456</TD><TD class="xl67">OUT</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:05</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">456</TD><TD class="xl67">OUT</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:45</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">456</TD><TD class="xl67">IN</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:30</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">456</TD><TD class="xl67">IN</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:50</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">789</TD><TD class="xl67">IN</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:22</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">789</TD><TD class="xl67">IN</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:55</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">456</TD><TD class="xl67">OUT</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">11:30</TD></TR><TR style="height: 15.0pt;"><TD class="xl67" height="20" style="height: 15.0pt;">123</TD><TD class="xl67">789</TD><TD class="xl67">OUT</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">11:00</TD></TR></TBODY></TABLE><P style="text-align: left;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>and I have also a dynamic variable:</P><P><IMG __jive_id="24667" class="jive-image" alt="interval.jpg" src="https://community.qlik.com/legacyfs/online/24667_interval.jpg" /></P><P></P><P>I need to create a report that shows all the call that took place within 20 minutes (or any other value from the slyder) between any couple Phone1-Phone2.</P><P>For example in this case and a 20 minute interval it will show:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 356px;"><TBODY><TR><TD align="left" height="20" width="64">Phone1</TD><TD align="left" width="64">Phone2</TD><TD align="left" width="89">Call direction</TD><TD align="left" width="75">date</TD><TD align="left" width="64">time</TD></TR><TR><TD align="right" height="20">123</TD><TD align="right">456</TD><TD align="left">IN</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:30</TD></TR><TR><TD align="right" height="20">123</TD><TD align="right">456</TD><TD align="left">OUT</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:45</TD></TR><TR><TD align="right" height="20">123</TD><TD align="right">456</TD><TD align="left">IN</TD><TD align="right" class="xl65">01/01/2012</TD><TD align="right" class="xl66">10:50</TD></TR></TBODY></TABLE><P></P><P>is it possible?</P><P>tnx <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><DIV class="mcePaste" id="_mcePaste" style="position: absolute; left: -10000px; top: 166px; width: 1px; height: 1px; overflow: hidden;"></DIV></BODY></HTML> Tue, 06 Nov 2012 09:25:04 GMT https://community.qlik.com/t5/QlikView/Dynamic-interval/m-p/404952#M568694 xtrimf 2012-11-06T09:25:04Z Re: Dynamic interval https://community.qlik.com/t5/QlikView/Dynamic-interval/m-p/404953#M568695 <HTML><HEAD></HEAD><BODY><P>anyone??</P></BODY></HTML> Wed, 07 Nov 2012 12:38:38 GMT https://community.qlik.com/t5/QlikView/Dynamic-interval/m-p/404953#M568695 xtrimf 2012-11-07T12:38:38Z