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

Data Model Help

Ok... I have this bar chart called Original Avg # Days in Routing, by Week that I need to change to use the dimension of ROUTING_WEEK_START instead of WEEK_START. Seems simple enough.

As you can see, these come from two different tables so I am unsure how to make this work. ROUTING_WEEK_START is part of a FACT table that is populated when a DEFECT_ID enters a PROCESS_STEP = "Submitted to Routing."

I created the CAL_ROUTING to see if I could make it work but it was unsuccessful.

Does anyone have any ideas?

2-7-2018 8-02-13 AM.jpg

2-7-2018 8-07-29 AM.jpg

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Based on the qvw, it does not appear that the ROUTING_WEEK_START in the APP_ALM table is calculated for PROCESS_STEP  values Routed and "Submitted to Routing".

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

Based on the qvw, it does not appear that the ROUTING_WEEK_START in the APP_ALM table is calculated for PROCESS_STEP  values Routed and "Submitted to Routing".