0 Replies Latest reply: Apr 18, 2013 3:38 AM by Alfred Shum RSS

    Concurrent event analysis

      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 sum of the followings:

       

      1. Any event happened at/after Start of Hour and ended before End of Hour
      2. Any event happened at/after Start of Hour and ended after the next hour
      3. Any event happened before Start of Hour and ended within the current hour
      4. Any event happened before Start of Hour and ended after the next hour

       

      The following diagram summarized the above situations:

       

      Concurrent events.png

       

      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.

       

      Excel attachment updated by Alfred Shum