topic Re: Event Within Timeframe of Another Event in QlikView

Event Within Timeframe of Another Event

dclark0699 — Fri, 08 Nov 2013 17:12:07 GMT

Hi,

I have a table of appointments (including appointment date) and a table of diagnoses(including diagnosis date)

Is it possible in load script to flag the answer to the question "Did you have xx Diagnosis within xx Months of your appointment?" for every appointment - without Cartesian joining the data together and subtracting dates?

Thanks!

Re: Event Within Timeframe of Another Event

swuehl — Fri, 08 Nov 2013 17:17:50 GMT

You can add the end date of the time periods to your appointment table (read the table in, for each appointment record, add xx months to the appointment date creating a new field).

Then use intervalmatch (the extended version to use patient ID as additional key) to map your diagnosis to the created intervals.

Re: Event Within Timeframe of Another Event

dclark0699 — Fri, 08 Nov 2013 17:25:27 GMT

This would work - but would it be possible to then remove the synthetic table Interval Match creates?

Re: Event Within Timeframe of Another Event

swuehl — Fri, 08 Nov 2013 23:55:07 GMT

Sure, you can join the tables if you want.