topic Offset date value to calculate demand for subproduct using demand from product and lead time in QlikView https://community.qlik.com/t5/QlikView/Offset-date-value-to-calculate-demand-for-subproduct-using/m-p/132249#M754443 <HTML><HEAD></HEAD><BODY><P>Hello Team,</P><P>I am trying to create qlikview PoC for my college to show how demand from product A flows to its subproduct A1/A3 using lead time and BOM.</P><P>I have created an excel sheet showing input&nbsp; sheet for demand table for Product and using lead time and BOM qty, i am calculating demand for subproduct A1 in output sheet.</P><P></P><P>Is there any scope to write the same in the load script? should i use below function to see values&nbsp; or any idea to arrive at desired output?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sathish_kumar 2020-11-25T16:16:04Z Offset date value to calculate demand for subproduct using demand from product and lead time https://community.qlik.com/t5/QlikView/Offset-date-value-to-calculate-demand-for-subproduct-using/m-p/132249#M754443 <HTML><HEAD></HEAD><BODY><P>Hello Team,</P><P>I am trying to create qlikview PoC for my college to show how demand from product A flows to its subproduct A1/A3 using lead time and BOM.</P><P>I have created an excel sheet showing input&nbsp; sheet for demand table for Product and using lead time and BOM qty, i am calculating demand for subproduct A1 in output sheet.</P><P></P><P>Is there any scope to write the same in the load script? should i use below function to see values&nbsp; or any idea to arrive at desired output?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Offset-date-value-to-calculate-demand-for-subproduct-using/m-p/132249#M754443 sathish_kumar 2020-11-25T16:16:04Z