topic Min(Date) Occurence and Rolling 8 Weeks in QlikView

Min(Date) Occurence and Rolling 8 Weeks

cbaqir — Thu, 08 Feb 2018 18:23:21 GMT

I have two expressions I need to modify to only use the first instance of the DEFECT_ID entering the GOV_PROCESS_QUEUE = 'ERC - Routing' and also to only show the previous rolling 8 weeks.

I was trying to use this but it's not working: ,ROUTING_WEEK_START = {"$(='>=' & Date(WeekStart(min({<GOV_PROCESS_QUEUE = {'ERC - Routing'}>MONTH_1), -8), 'MM-DD-YY') & '<' & Date(WeekStart(min({<GOV_PROCESS_QUEUE = {'ERC - Routing'}}>}MONTH_1), 0), 'MM-DD-YY'))"}

Avg Days expression:

aggr(avg({$<GOV_PROCESS_QUEUE = {'ERC - Routing'}>}GOV_PROCESS_QUEUE_TAT), DEFECT_ID)

Ticket Count expression:

count({$<
GOV_PROCESS_QUEUE = {'ERC - Routing'}
>}
DISTINCT DEFECT_ID)

Suggestions?

Thanks in Advance!

Re: Min(Date) Occurence and Rolling 8 Weeks

cbaqir — Mon, 12 Feb 2018 14:36:43 GMT

stalwar1‌

Re: Min(Date) Occurence and Rolling 8 Weeks

Anil_Babu_Samineni — Mon, 12 Feb 2018 15:17:47 GMT

I have not seen anything related your measures? Not sure, You uploaded latest version or not?

Re: Min(Date) Occurence and Rolling 8 Weeks

cbaqir — Mon, 12 Feb 2018 16:20:54 GMT

Not sure what the issue is. It is the right file.

Re: Min(Date) Occurence and Rolling 8 Weeks

Anil_Babu_Samineni — Mon, 12 Feb 2018 16:45:50 GMT

I am getting this?

Re: Min(Date) Occurence and Rolling 8 Weeks

cbaqir — Mon, 12 Feb 2018 17:22:22 GMT

You were right. I had the tab conditionally hidden. The right file is there now.

Re: Min(Date) Occurence and Rolling 8 Weeks

Anil_Babu_Samineni — Mon, 12 Feb 2018 17:54:27 GMT

Here we go, Finally in single shot.

count({$<GOV_PROCESS_QUEUE = {'ERC - Routing'},

ROUTING_WEEK_START={">=$(=Date(WeekStart(max({<GOV_PROCESS_QUEUE = {'ERC - Routing'}>}MONTH_1), -8), 'MM/DD/YY'))<=$(=Date(WeekStart(max({<GOV_PROCESS_QUEUE = {'ERC - Routing'}>}MONTH_1), 0), 'MM/DD/YY'))"}>}DISTINCT DEFECT_ID)

aggr(avg({$<GOV_PROCESS_QUEUE = {'ERC - Routing'},

Re: Min(Date) Occurence and Rolling 8 Weeks

cbaqir — Mon, 12 Feb 2018 19:06:37 GMT

I think this is close but not exactly what I need. Because a DEFECT_ID can go through this step multiple times, the rolling 8 weeks could show a count for the most current week but the avg days from months ago (like below). How do I always just show the last 8 weeks if the avg days could be associated with the first week and the count is associated with later weeks?

Re: Min(Date) Occurence and Rolling 8 Weeks

Anil_Babu_Samineni — Tue, 13 Feb 2018 13:46:37 GMT

You can set irrespective selection for that like

aggr(avg({1<GOV_PROCESS_QUEUE = {'ERC - Routing'},

Re: Min(Date) Occurence and Rolling 8 Weeks

cbaqir — Tue, 13 Feb 2018 15:04:30 GMT

thanks