topic Re: Data Model Help in QlikView https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/65652#M10914 <HTML><HEAD></HEAD><BODY><P>Based on the qvw, it does not appear that the ROUTING_WEEK_START in the APP_ALM table is calculated for PROCESS_STEP&nbsp; values Routed and "Submitted to Routing".</P></BODY></HTML> Wed, 07 Feb 2018 22:50:37 GMT jwjackso 2018-02-07T22:50:37Z Data Model Help https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/65651#M10913 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>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."</P><P></P><P>I created the CAL_ROUTING to see if I could make it work but it was unsuccessful.</P><P></P><P>Does anyone have any ideas?</P><P></P><P><IMG alt="2-7-2018 8-02-13 AM.jpg" class="jive-image image-1" src="/legacyfs/online/192718_2-7-2018 8-02-13 AM.jpg" style="width: 620px; height: 809px;" /></P><P></P><P><IMG alt="2-7-2018 8-07-29 AM.jpg" class="jive-image image-2" src="/legacyfs/online/192734_2-7-2018 8-07-29 AM.jpg" style="width: 620px; height: 441px;" /></P></BODY></HTML> Wed, 07 Feb 2018 15:09:37 GMT https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/65651#M10913 cbaqir 2018-02-07T15:09:37Z Re: Data Model Help https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/65652#M10914 <HTML><HEAD></HEAD><BODY><P>Based on the qvw, it does not appear that the ROUTING_WEEK_START in the APP_ALM table is calculated for PROCESS_STEP&nbsp; values Routed and "Submitted to Routing".</P></BODY></HTML> Wed, 07 Feb 2018 22:50:37 GMT https://community.qlik.com/t5/QlikView/Data-Model-Help/m-p/65652#M10914 jwjackso 2018-02-07T22:50:37Z