Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
us_enterprise_s
Contributor III
Contributor III

Set analysis help needed

Hi,

I am working on a set analysis expression and have been struggling with the last piece.

I appreciate all help.

=aggr

(

     only

     (

          {$

               <PatientName=P({$<ScanType={'XR'}>}PatientName)>

                    *

               <PatientName=P({$<ScanType={'CT'}>}PatientName)>

          }

     PatientName

     ),

PatientName

)

Existing expression correctly identifies all patients who had both 'XR' and 'CT'. I need to further modify it, so that it only looks for patients who had a XR, within 40 days prior to the CT.

I have a field, ScanStart, that tells me when the scan took place.

1 Reply
us_enterprise_s
Contributor III
Contributor III
Author

nothing?