Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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

Community Browser