Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

intersection set analysis

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.

Labels (2)
1 Solution

Accepted Solutions
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

1 Reply
Digital Support
Digital Support

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post