https://community.qlik.com/t5/QlikView/Set-Analysis-Intersection/m-p/1847109#M1215499 <P>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 &gt;= AddMonths(Today(),-12) AND where the CLOSE_DATE&nbsp;&gt;= AddMonths(Today(),-3).</P><P><FONT color="#FF0000">Count({$&lt;DEFECT_ID *= {"=Min({1}DETECT_DATE) &gt;= AddMonths(Today(),-12)"}&gt;}DISTINCT DEFECT_ID)</FONT></P><P><FONT color="#FF0000">Count({$&lt;DEFECT_ID *= {"=Min({1}CLOSE_DATE) &gt;= AddMonths(Today(),-3)"}&gt;}DISTINCT DEFECT_ID)</FONT></P> Thu, 14 Oct 2021 20:30:53 GMT cbaqir 2021-10-14T20:30:53Z https://community.qlik.com/t5/QlikView/Set-Analysis-Intersection/m-p/1847109#M1215499 <P>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 &gt;= AddMonths(Today(),-12) AND where the CLOSE_DATE&nbsp;&gt;= AddMonths(Today(),-3).</P><P><FONT color="#FF0000">Count({$&lt;DEFECT_ID *= {"=Min({1}DETECT_DATE) &gt;= AddMonths(Today(),-12)"}&gt;}DISTINCT DEFECT_ID)</FONT></P><P><FONT color="#FF0000">Count({$&lt;DEFECT_ID *= {"=Min({1}CLOSE_DATE) &gt;= AddMonths(Today(),-3)"}&gt;}DISTINCT DEFECT_ID)</FONT></P> Thu, 14 Oct 2021 20:30:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Intersection/m-p/1847109#M1215499 cbaqir 2021-10-14T20:30:53Z https://community.qlik.com/t5/QlikView/Set-Analysis-Intersection/m-p/1847110#M1215500 <P><SPAN>Count({$&lt;DEFECT_ID *= {"=Min({1}DETECT_DATE) &gt;= AddMonths(Today(),-12) and Min({1}CLOSE_DATE) &gt;= AddMonths(Today(),-3)"}&gt;}DISTINCT DEFECT_ID)</SPAN></P> Thu, 14 Oct 2021 20:42:08 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Intersection/m-p/1847110#M1215500 stevejoyce 2021-10-14T20:42:08Z