Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
WalidChoukri
Contributor III
Contributor III

Rolling Quantity

Hello Everyone,

I'm trying to get the Rolling quantity of a product, I'm using this code in the script :

Demande:
LOAD *,
If(Article = Previous(Article),Rangesum(Quantité_ND,Peek('Rolling')),Quantité_ND)as Rolling
Resident ND
Order By Article, YearWeek;
drop Table ND;

Article, YearWeek and 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.

Many thanks.

1.PNG

 

2.PNG

Labels (1)
  • Peek

0 Replies