topic Concurrent event analysis in QlikView https://community.qlik.com/t5/QlikView/Concurrent-event-analysis/m-p/466214#M486162 <HTML><HEAD></HEAD><BODY><P>I'm new in QlikView and I'm trying to convert my masterpiece from Excel to QlikView. The attached Excel file shows the analysis of the number of concurrent events within a particular hour. The formula to determine the number of concurrent incidents within an hour is the <STRONG>sum of the followings</STRONG>:</P><P></P><OL start="1"><LI>Any event happened at/after <STRONG>Start of Hour </STRONG>and ended before <STRONG>End of Hour</STRONG></LI><LI>Any event happened at/after Start of Hour and ended after the next hour</LI><LI>Any event happened before Start of Hour and ended within the current hour</LI><LI>Any event happened before Start of Hour and ended after the next hour</LI></OL><P></P><P>The following diagram summarized the above situations:</P><P></P><P><IMG __jive_id="39088" alt="Concurrent events.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39088_Concurrent+events.png" width="450" /></P><P></P><P>The Excel formula I used on the "Analysis" Worksheet (see Column I) is an array function to do the sum of the above 4 scenarios. What should be the equivalent QlikView Edit Script syntax for this? I read some of the threads about IntervalMatch () with Count(distinct) but seems that is not generating the data I need.</P><P></P><P>Excel attachment updated by Alfred Shum</P></BODY></HTML> Thu, 18 Apr 2013 07:38:33 GMT 2013-04-18T07:38:33Z Concurrent event analysis https://community.qlik.com/t5/QlikView/Concurrent-event-analysis/m-p/466214#M486162 <HTML><HEAD></HEAD><BODY><P>I'm new in QlikView and I'm trying to convert my masterpiece from Excel to QlikView. The attached Excel file shows the analysis of the number of concurrent events within a particular hour. The formula to determine the number of concurrent incidents within an hour is the <STRONG>sum of the followings</STRONG>:</P><P></P><OL start="1"><LI>Any event happened at/after <STRONG>Start of Hour </STRONG>and ended before <STRONG>End of Hour</STRONG></LI><LI>Any event happened at/after Start of Hour and ended after the next hour</LI><LI>Any event happened before Start of Hour and ended within the current hour</LI><LI>Any event happened before Start of Hour and ended after the next hour</LI></OL><P></P><P>The following diagram summarized the above situations:</P><P></P><P><IMG __jive_id="39088" alt="Concurrent events.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39088_Concurrent+events.png" width="450" /></P><P></P><P>The Excel formula I used on the "Analysis" Worksheet (see Column I) is an array function to do the sum of the above 4 scenarios. What should be the equivalent QlikView Edit Script syntax for this? I read some of the threads about IntervalMatch () with Count(distinct) but seems that is not generating the data I need.</P><P></P><P>Excel attachment updated by Alfred Shum</P></BODY></HTML> Thu, 18 Apr 2013 07:38:33 GMT https://community.qlik.com/t5/QlikView/Concurrent-event-analysis/m-p/466214#M486162 2013-04-18T07:38:33Z