intersection set analysis

cbaqir — Fri, 15 Nov 2024 23:57:19 GMT

I am trying to write an expressions that gives me the average days per DEFECT_ID between a combination of ADJ_GOVERNANCE_PHASE = 3.2* (which has ADJ_GOVERNANCE_PHASE_END_DATE or ADJ_GOVERNANCE_PHASE_START_DATE) and TICKET_STATUS = Complete (which uses STATUS_START_DATE) through ADJ_GOVERNANCE_PHASE = 4.1* (which has ADJ_GOVERNANCE_PHASE_START_DATE).

I am struggling to see if this is even possible using intersection.

I've attached a QVW. DEFECT_ID = 312 is an example. ADJ_GOVERNANCE_PHASE = 3.2* AND TICKET_STATUS = Complete should be 3/9/2020 and ADJ_GOVERNANCE_PHASE = 4.1* has ADJ_GOVERNANCE_PHASE_START_DATE = 3/10/20. For this DEFECT_ID, I expect it to show 1 .x days and then I need to have the aggr avg for DEFECT_ID

Intersection Set Anaysis: =sum({<DEFECT_ID=P({<ADJ_GOVERNANCE_PHASE={'3.2*'}>}ADJ_GOVERNANCE_PHASE_END_DATE)>*<DEFECT_ID=P({<TICKET_STATUS={'Complete'}>}STATUS_START_DATE)>*<DEFECT_ID=P({<ADJ_GOVERNANCE_PHASE={'4.1*'}>}ADJ_GOVERNANCE_PHASE_START_DATE)>} distinct DEFECT_ID)

Thank you.

Re: intersection set analysis

Brett_Bleess — Wed, 14 Oct 2020 14:56:43 GMT

Just bumping this to put it back in the top of the queue to see if one of the Set Analysis gurus can have a look and provide some feedback, I am afraid I am not much help to you directly, but hopefully one of the other guys will be able to have a look and leave some ideas.

Regards,
Brett

topic Re: intersection set analysis in QlikView

intersection set analysis

Re: intersection set analysis