Tracking How Many Are Active With Activate Date & Deactivate Date

Wed, 06 Jul 2016 19:59:51 GMT

Hello all,

I have a set of data that tracks [Issue]s. Each [Issue] has a [Created On] date and a [Resolved On] date.

(See image for example)

I need to track, in a chart, how many issues are active each month.

An issue is active if it was created before or during the current month & resolved during that month, during a later month, or never.

Any Ideas?

Re: Tracking How Many Are Active With Activate Date & Deactivate Date

sunny_talwar — Wed, 06 Jul 2016 21:41:26 GMT

I think you need to either use IntervalMatch or While loop to populate all the months between the created on and resolved on date to be able to do this. There might be a way to do this on the front end, but that could hurt performance

topic Re: Tracking How Many Are Active With Activate Date & Deactivate Date in QlikView

Tracking How Many Are Active With Activate Date & Deactivate Date

Re: Tracking How Many Are Active With Activate Date & Deactivate Date