topic Accumulate with Cap in QlikView

topic Accumulate with Cap in QlikView https://community.qlik.com/t5/QlikView/Accumulate-with-Cap/m-p/2073930#M1223745 <P>I have Capacity  , On hand , Backorder, Need, Saeftystock quantities.</P> <OL> <LI>For each period I Calculated the net need as (Capacity + On hand - Backorder - Need - SaeftyStock)</LI> <LI>What has been calculated at point 1 , needs to be carried over through the periods, with a maximum cap driven by Saefty Stock (so the carry over amount cannot be more than saefty stock value )</LI> </OL> <UL> <LI>Here below i put all the measure  (Capacity , on hand , backorder , need , saefty stock) and i summarized by <STRONG>Available </STRONG><SPAN> </SPAN>and <STRONG>Need</STRONG><SPAN> </SPAN>with the difference shown as <STRONG>NET</STRONG></LI> <LI><FONT color="#339966">On the <STRONG>Expected Carryover </STRONG>is what i expect to get from a formula</FONT></LI> <LI>On the <STRONG>Carryover</STRONG><SPAN> </SPAN>i set the formula suggested, but is not working as expected</LI> </UL> <P> </P> <P>Do you mind to help me in understanding what i'm missing? Thank you!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikviewaf_0-1684766905298.png" style="width: 749px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/107706iFD1D8E8D4AA30212/image-dimensions/749x206?v=v2" width="749" height="206" role="button" title="qlikviewaf_0-1684766905298.png" alt="qlikviewaf_0-1684766905298.png" /></span></P> <P> </P> Mon, 22 May 2023 14:50:50 GMT qlikviewaf 2023-05-22T14:50:50Z Accumulate with Cap https://community.qlik.com/t5/QlikView/Accumulate-with-Cap/m-p/2073930#M1223745 <P>I have Capacity  , On hand , Backorder, Need, Saeftystock quantities.</P> <OL> <LI>For each period I Calculated the net need as (Capacity + On hand - Backorder - Need - SaeftyStock)</LI> <LI>What has been calculated at point 1 , needs to be carried over through the periods, with a maximum cap driven by Saefty Stock (so the carry over amount cannot be more than saefty stock value )</LI> </OL> <UL> <LI>Here below i put all the measure  (Capacity , on hand , backorder , need , saefty stock) and i summarized by <STRONG>Available </STRONG><SPAN> </SPAN>and <STRONG>Need</STRONG><SPAN> </SPAN>with the difference shown as <STRONG>NET</STRONG></LI> <LI><FONT color="#339966">On the <STRONG>Expected Carryover </STRONG>is what i expect to get from a formula</FONT></LI> <LI>On the <STRONG>Carryover</STRONG><SPAN> </SPAN>i set the formula suggested, but is not working as expected</LI> </UL> <P> </P> <P>Do you mind to help me in understanding what i'm missing? Thank you!</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="qlikviewaf_0-1684766905298.png" style="width: 749px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/107706iFD1D8E8D4AA30212/image-dimensions/749x206?v=v2" width="749" height="206" role="button" title="qlikviewaf_0-1684766905298.png" alt="qlikviewaf_0-1684766905298.png" /></span></P> <P> </P> Mon, 22 May 2023 14:50:50 GMT https://community.qlik.com/t5/QlikView/Accumulate-with-Cap/m-p/2073930#M1223745 qlikviewaf 2023-05-22T14:50:50Z