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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Set Analysis Intersection

Can someone help me with the right syntax to get the intersection of these expressions? I am trying to get the counts of DEFECT_ID where the DETECT_DATE >= AddMonths(Today(),-12) AND where the CLOSE_DATE >= AddMonths(Today(),-3).

Count({$<DEFECT_ID *= {"=Min({1}DETECT_DATE) >= AddMonths(Today(),-12)"}>}DISTINCT DEFECT_ID)

Count({$<DEFECT_ID *= {"=Min({1}CLOSE_DATE) >= AddMonths(Today(),-3)"}>}DISTINCT DEFECT_ID)

Labels (2)
1 Reply
stevejoyce
Specialist II
Specialist II

Count({$<DEFECT_ID *= {"=Min({1}DETECT_DATE) >= AddMonths(Today(),-12) and Min({1}CLOSE_DATE) >= AddMonths(Today(),-3)"}>}DISTINCT DEFECT_ID)