https://community.qlik.com/t5/QlikView/Rolling-Quantity/m-p/1773293#M717991 <P>Hello Everyone,</P><P>I'm trying to get the Rolling quantity of a product, I'm using this code in the script :</P><P>Demande:<BR />LOAD *,<BR />If(Article = Previous(Article),Rangesum(Quantité_ND,Peek('Rolling')),Quantité_ND)as Rolling<BR />Resident ND<BR />Order By Article, YearWeek;<BR />drop Table ND;</P><P>Article,&nbsp;YearWeek and&nbsp;Quantité_ND are fields in the table ND, however the result i'm getting is confusing, as you can see in the screenshot below, can you help me guys, what i'm doing wrong.</P><P>Many thanks.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="1.PNG" style="width: 240px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46746iFCF8E2DED046A6ED/image-size/large?v=v2&amp;px=999" role="button" title="1.PNG" alt="1.PNG" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 670px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46747iCA9086C6AF42F747/image-size/large?v=v2&amp;px=999" role="button" title="2.PNG" alt="2.PNG" /></span></P> Fri, 15 Nov 2024 23:20:53 GMT WalidChoukri 2024-11-15T23:20:53Z https://community.qlik.com/t5/QlikView/Rolling-Quantity/m-p/1773293#M717991 <P>Hello Everyone,</P><P>I'm trying to get the Rolling quantity of a product, I'm using this code in the script :</P><P>Demande:<BR />LOAD *,<BR />If(Article = Previous(Article),Rangesum(Quantité_ND,Peek('Rolling')),Quantité_ND)as Rolling<BR />Resident ND<BR />Order By Article, YearWeek;<BR />drop Table ND;</P><P>Article,&nbsp;YearWeek and&nbsp;Quantité_ND are fields in the table ND, however the result i'm getting is confusing, as you can see in the screenshot below, can you help me guys, what i'm doing wrong.</P><P>Many thanks.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="1.PNG" style="width: 240px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46746iFCF8E2DED046A6ED/image-size/large?v=v2&amp;px=999" role="button" title="1.PNG" alt="1.PNG" /></span></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.PNG" style="width: 670px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/46747iCA9086C6AF42F747/image-size/large?v=v2&amp;px=999" role="button" title="2.PNG" alt="2.PNG" /></span></P> Fri, 15 Nov 2024 23:20:53 GMT https://community.qlik.com/t5/QlikView/Rolling-Quantity/m-p/1773293#M717991 WalidChoukri 2024-11-15T23:20:53Z