topic Re: Visit Type within 6 Months in Archived Groups

Visit Type within 6 Months

detmawin — Tue, 22 Jul 2025 14:29:37 GMT

I am trying to get the first patient with a new patient visit type within 6 month of the physician or follow up visit. If a patient has a new patient visit and has no other activities (physician or follow up visit types) within 6 months then a new patient visit type is needed.

If the patient has only a new patient visit, I can take the first value. But if a patient has a new patient visit, then a physician or follow up visit past six months, I am not sure how to grab this date. I attached a spreadsheet of sample data.

Thank you

Re: Visit Type within 6 Months

Dalton_Ruer — Wed, 16 Oct 2019 13:30:20 GMT

That is a very common thing to do and the answer is to use the PREVIOUS command inside your LOAD script.

Check out this blog post I created about something very similar that had to do with READMISSIONS to read and see the logic and code behind it: http://qlikdork.com/2016/07/visualizing-readmissions/

The Qlik Help for the PREVIOUS function is pretty thorough if you need to check it out more: https://help.qlik.com/en-US/sense/September2019/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Previous.htm