Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
cbaqirdhds
Valued Contributor

Min(Date) Occurence and Rolling 8 Weeks

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!

Tags (3)
1 Solution

Accepted Solutions

Re: Min(Date) Occurence and Rolling 8 Weeks

You can set irrespective selection for that like

aggr(avg({1<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'))"}>}GOV_PROCESS_QUEUE_TAT), DEFECT_ID)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
9 Replies
cbaqirdhds
Valued Contributor

Re: Min(Date) Occurence and Rolling 8 Weeks

Re: Min(Date) Occurence and Rolling 8 Weeks

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
cbaqirdhds
Valued Contributor

Re: Min(Date) Occurence and Rolling 8 Weeks

Not sure what the issue is. It is the right file.2-12-2018 9-20-14 AM.jpg

Re: Min(Date) Occurence and Rolling 8 Weeks

I am getting this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
cbaqirdhds
Valued Contributor

Re: Min(Date) Occurence and Rolling 8 Weeks

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

Re: Min(Date) Occurence and Rolling 8 Weeks

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'},

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'))"}>}GOV_PROCESS_QUEUE_TAT), DEFECT_ID)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
cbaqirdhds
Valued Contributor

Re: Min(Date) Occurence and Rolling 8 Weeks

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?

2-12-2018 11-33-24 AM.jpg

Re: Min(Date) Occurence and Rolling 8 Weeks

You can set irrespective selection for that like

aggr(avg({1<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'))"}>}GOV_PROCESS_QUEUE_TAT), DEFECT_ID)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
cbaqirdhds
Valued Contributor

Re: Min(Date) Occurence and Rolling 8 Weeks

thanks