Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
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 (1)
1 Reply
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)