topic Re: Contact Date Within Status Period in QlikView

Contact Date Within Status Period

quilldew — Wed, 13 Feb 2019 16:07:24 GMT

Hi,

I have a set of data where a client can have a given status - such as LAC - that is represented by a start date and end date eg: LAC_StartDate, LAC_EndDate

These clients (identified by a unique ID) can have lots of contacts, what I need to do is mark a contact with a flag if it took place within the LAC status period for that client, and only that client.

I did a search and found lots of interval match references for linking dates to general periods, but I couldn't find anything to link a date filtered by client, to a period filtered by the same client.

Any ideas?

Re: Contact Date Within Status Period

Vegar — Wed, 13 Feb 2019 22:11:44 GMT

By the sound of your description I sounds like a interval match scenario. Have you looked into the extended syntax of IntervalMatch?
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/IntervalMatch_(Extended_Syntax).htm

If this is not helping you then I would recommend you put up a screenshot and or share some sample data.

Re: Contact Date Within Status Period

quilldew — Tue, 19 Feb 2019 08:27:45 GMT

Okay,

It took me a while to create some random data in roughly the format I need.

I've attached a qvw.

I've had a good look at extended intervalmatch, but I'm not sure it's what I need as I already have the contacts linked to another range.

I'm looking to show anyone with a LAC referral open during a contact_quarter I pick, that also had a contact with another service, during that same quarter, and also while the LAC referral was open. I haven't included any here, but all the referrals may have empty end_date's ie: still open.

Does that make sense? Not sure :S

Re: Contact Date Within Status Period

quilldew — Thu, 21 Feb 2019 14:03:23 GMT

Are we thinking it's just not possible?