https://community.qlik.com/t5/QlikView/intersection-set-analysis/m-p/1681094#M450072 <P>I am building a chart and the expression needs to be the average days (aggr at the DEFECT_ID level) between the min ADJ_GOVERNANCE_PHASE_START_DATE where ADJ_GOVERNANCE_PHASE = '4.3 - Non-Prod Build &amp; Testing' and min ADJ_GOVERNANCE_PHASE_START_DATE where&nbsp; ADJ_GOVERNANCE_PHASE = '4.8 - Prod Build &amp; Validation' <STRONG>AND</STRONG> TICKET_STATUS = 'Ready for Validation Prod'</P><P>Can someone please help me?</P><P>aggr(min( {$&lt;ADJ_GOVERNANCE_PHASE={'4.8*'},TICKET_STATUS={'Ready for Prod Validation'} &gt;} ADJ_GOVERNANCE_PHASE_START_DATE)-min( {$&lt;ADJ_GOVERNANCE_PHASE={'4.3*'} &gt;} ADJ_GOVERNANCE_PHASE_START_DATE),DEFECT_ID)</P> Sat, 16 Nov 2024 01:08:53 GMT cbaqir 2024-11-16T01:08:53Z https://community.qlik.com/t5/QlikView/intersection-set-analysis/m-p/1681094#M450072 <P>I am building a chart and the expression needs to be the average days (aggr at the DEFECT_ID level) between the min ADJ_GOVERNANCE_PHASE_START_DATE where ADJ_GOVERNANCE_PHASE = '4.3 - Non-Prod Build &amp; Testing' and min ADJ_GOVERNANCE_PHASE_START_DATE where&nbsp; ADJ_GOVERNANCE_PHASE = '4.8 - Prod Build &amp; Validation' <STRONG>AND</STRONG> TICKET_STATUS = 'Ready for Validation Prod'</P><P>Can someone please help me?</P><P>aggr(min( {$&lt;ADJ_GOVERNANCE_PHASE={'4.8*'},TICKET_STATUS={'Ready for Prod Validation'} &gt;} ADJ_GOVERNANCE_PHASE_START_DATE)-min( {$&lt;ADJ_GOVERNANCE_PHASE={'4.3*'} &gt;} ADJ_GOVERNANCE_PHASE_START_DATE),DEFECT_ID)</P> Sat, 16 Nov 2024 01:08:53 GMT https://community.qlik.com/t5/QlikView/intersection-set-analysis/m-p/1681094#M450072 cbaqir 2024-11-16T01:08:53Z