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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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?