https://community.qlik.com/t5/App-Development/Help-Overwriting-Data-to-Reflect-Final-Condition-of-Dimension/m-p/1891144#M73434 <P>Hello, I am currently developing an application and hit somewhat of a roadblock. The application that I am developing monitors production processing times of different types of assemblies. As assemblies move through the production process cycle times are automatically recorded for the respective serial number.&nbsp;</P> <P>&nbsp;</P> <P>The issue arises from the fact that all assemblies start out as the same part number but then depending on demand they may change to an alternate assembly. Furthermore, their serial number will also change if they undergo the part number change.&nbsp;</P> <P>&nbsp;</P> <P>What I would like to do is make my dataset consistent and override all data with the final condition of the assembly. This is because both the final serial number and part number are what is tracked. I have provided an illustration of this below.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="QLIKSC1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71967iDADC9306E0FD5865/image-size/medium?v=v2&amp;px=400" role="button" title="QLIKSC1.JPG" alt="QLIKSC1.JPG" /></span></P> <P>&nbsp;Thank you in advance for any advice on how to tackle this problem.&nbsp;</P> Fri, 11 Feb 2022 19:10:02 GMT Kosakamaka 2022-02-11T19:10:02Z https://community.qlik.com/t5/App-Development/Help-Overwriting-Data-to-Reflect-Final-Condition-of-Dimension/m-p/1891144#M73434 <P>Hello, I am currently developing an application and hit somewhat of a roadblock. The application that I am developing monitors production processing times of different types of assemblies. As assemblies move through the production process cycle times are automatically recorded for the respective serial number.&nbsp;</P> <P>&nbsp;</P> <P>The issue arises from the fact that all assemblies start out as the same part number but then depending on demand they may change to an alternate assembly. Furthermore, their serial number will also change if they undergo the part number change.&nbsp;</P> <P>&nbsp;</P> <P>What I would like to do is make my dataset consistent and override all data with the final condition of the assembly. This is because both the final serial number and part number are what is tracked. I have provided an illustration of this below.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="QLIKSC1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/71967iDADC9306E0FD5865/image-size/medium?v=v2&amp;px=400" role="button" title="QLIKSC1.JPG" alt="QLIKSC1.JPG" /></span></P> <P>&nbsp;Thank you in advance for any advice on how to tackle this problem.&nbsp;</P> Fri, 11 Feb 2022 19:10:02 GMT https://community.qlik.com/t5/App-Development/Help-Overwriting-Data-to-Reflect-Final-Condition-of-Dimension/m-p/1891144#M73434 Kosakamaka 2022-02-11T19:10:02Z https://community.qlik.com/t5/App-Development/Help-Overwriting-Data-to-Reflect-Final-Condition-of-Dimension/m-p/1892119#M73517 <P>Any help on this topic would be greatly appreciated.&nbsp;</P> Fri, 11 Feb 2022 19:10:22 GMT https://community.qlik.com/t5/App-Development/Help-Overwriting-Data-to-Reflect-Final-Condition-of-Dimension/m-p/1892119#M73517 Kosakamaka 2022-02-11T19:10:22Z