Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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?