Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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