Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

intersection set analysis

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 & Testing' and min ADJ_GOVERNANCE_PHASE_START_DATE where  ADJ_GOVERNANCE_PHASE = '4.8 - Prod Build & Validation' AND TICKET_STATUS = 'Ready for Validation Prod'

Can someone please help me?

aggr(min( {$<ADJ_GOVERNANCE_PHASE={'4.8*'},TICKET_STATUS={'Ready for Prod Validation'} >} ADJ_GOVERNANCE_PHASE_START_DATE)-min( {$<ADJ_GOVERNANCE_PHASE={'4.3*'} >} ADJ_GOVERNANCE_PHASE_START_DATE),DEFECT_ID)

Labels (1)