topic Interval Match two periods in QlikView

Interval Match two periods

rwunderlich — Wed, 20 Jan 2010 02:04:44 GMT

I'm trying to do an IntervalMatch (or set analysis alternative) to be able to determine a headcount for any given date. A sample qvw is attached.

On any given date, I should be able to get a count of DISTINCT EmpKey for any combination of Dept and Status. It kind of works with IntervalMatch, but it will be messy when I try to scale it up to 50k employees.

Any other solutions, or a cleaner IntervalMatch?

Thanks,

-Rob

Interval Match two periods

Thu, 08 Apr 2010 13:11:14 GMT

Hi Rob,

Did you ever get anywhere with this?

Regards,

Neil

Interval Match two periods

Oleg_Troyansky — Fri, 09 Apr 2010 05:19:10 GMT

Rob,

tough case... sorry, haven't seen your question before... I assume you found one solution or another by now.

I'd consider concatenating Activities and Locations into a single table (with the same names for StartDate and EndDate fields) and differentiating between the two types of data using flags. This way, you only need a single INTERVALMATCH, and the whole picture might become a bit less ugly...

just a thought...