topic Re: Tricky set analysis question? in QlikView

Tricky set analysis question?

baylor2016 — Thu, 20 Jul 2017 16:41:13 GMT

Hi,

Here is my question:- Get all the patient visits (before a selected date) for the patients who visited clinic in the previous three days based upon user selected date. For example, if user selected 1/7/2017, Patient1,2,3,5 had visits between 1/5/2017 and 1/7/2017, I need to get all the visits before 1/7/2017 (not only the visits between 1/5/2017 and 1/7/2017) for these patient. Right now I can only get the patient visits in the past three days before the selected date by using set analysis (below) in straight table.

=max(

VisitDate=,

VisitDate = {"$(='>=' & Date(V_3DaysAgo) & '<=' & Date(V_SELECTED))"}

VisitDate)

Here V_SELECTED and V_3DaysAgo are the variable I defined.

I created a simple sample attached.

Many thanks!!!

Longmatch

Re: Tricky set analysis question?

sunny_talwar — Thu, 20 Jul 2017 17:04:22 GMT

Try this

=min(

VisitDate = {"$(='<=' & Date(V_SELECTED))"},

patientID = p({<VisitDate = {"$(='>=' & Date(V_3DaysAgo) & '<=' & Date(V_SELECTED))"}>} patientID)

VisitDate)

Re: Tricky set analysis question?

baylor2016 — Thu, 20 Jul 2017 17:23:16 GMT

Thank you for the quick response. I do not know p() modifier. It will allow me to do a lot of things.