topic Re: Set Analysis in QlikView

Set Analysis

cbaqir — Thu, 10 Aug 2017 16:14:25 GMT

This works: ='Closed/Created w/i 6 months (Correct): ' & Count({$<CUR_STATUS = {'Closed'},DEFECT_ID *= {"=Min({1<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) >= AddMonths(Today(),-6) and Min({1<DEFECT_STATUS={'New'}>} DEFECT_STATUS_START_DATE)
< Today()"}*e( {1< PRIMARY_DECISION_BODY ={'SMG Committee'}>})>} DISTINCT DEFECT_ID)

Requirement:

CUR_STATUS = Closed during last 6 months when opened(min DEFECT_START_DATE of DEFECT_STATUS = New) before 6 months; Exclude Primary Decision Body = 'SMG Committee'

How do I take the expression 'Closed/Created w/i 6 months' and modify it to show when opened(min DEFECT_START_DATE of DEFECT_STATUS = New) before 6 months?

TIA!

Re: Set Analysis

sunny_talwar — Thu, 10 Aug 2017 16:21:36 GMT

What would the expected number you are looking to get?

Re: Set Analysis

cbaqir — Thu, 10 Aug 2017 16:22:49 GMT

~419 give or take a few

Re: Set Analysis

sunny_talwar — Thu, 10 Aug 2017 16:28:29 GMT

Can you provide a single Defect_ID which you know meet the criteria?

Re: Set Analysis

cbaqir — Thu, 10 Aug 2017 16:30:26 GMT

3468

Re: Set Analysis

sunny_talwar — Thu, 10 Aug 2017 16:33:22 GMT

This got me to 390

='Closed w/i 6 months; Created >6 months: (Expected: ~419): ' & Count({$<PRIMARY_DECISION_BODY-={'SMG Committee'},DEFECT_ID =

{"=Min({<DEFECT_STATUS={'New'}>}DEFECT_STATUS_START_DATE) < AddMonths(Today(),-6) and Max({<CUR_STATUS={'Closed'}>}DEFECT_STATUS_START_DATE) >= AddMonths(Today(),-6)"}>} DISTINCT DEFECT_ID)

Re: Set Analysis

cbaqir — Thu, 10 Aug 2017 16:35:03 GMT

Thanks, let me check it out

Re: Set Analysis

sunny_talwar — Thu, 10 Aug 2017 16:35:54 GMT

Sure thing