Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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?