Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

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!

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)

View solution in original post

9 Replies
cbaqir
Specialist II
Specialist II
Author

Anil_Babu_Samineni

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
cbaqir
Specialist II
Specialist II
Author

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

Anil_Babu_Samineni

I am getting this?

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
cbaqir
Specialist II
Specialist II
Author

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

Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
cbaqir
Specialist II
Specialist II
Author

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

Anil_Babu_Samineni

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)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
cbaqir
Specialist II
Specialist II
Author

thanks