Rolling Qty

Eaun — Wed, 04 Mar 2020 14:12:55 GMT

How can I reproduce the formula in column J in this excel sheet to do a rolling Qty on the on hand qty in qlik sense on a pivot table ?

I've had no luck so far : (

Re: Rolling Qty

Eaun — Thu, 05 Mar 2020 09:52:46 GMT

Tried this :

Test:
LOAD
Rowno() as RowNumber,
PROCESS_CODE,
LINE_CODE,
PART_NUMBER,
CUSTOMER_P_O_NUMBER,
SHIPPING_DATE,
"ORDER QTY",
"SHIPPED QTY",
"REMAINING QTY TO SHIP",
"ON HAND QTY" as [On Hand Rolling Qty],
"ON HAND QTY"
FROM [lib://Qlik Test/Other source files/Rolling Qty.xlsx]
(ooxml, embedded labels, table is Rad2);

Left Join (Test)
Load Distinct
RowNumber,
if( alt(previous([On Hand Rolling Qty]),0)>=0,
alt(previous([On Hand Rolling Qty])-[REMAINING QTY TO SHIP],
alt(previous([On Hand Rolling Qty])-[SHIPPED QTY] ))) as [Rolling Qty]

Resident Test;

but the last row does not down date : (

Any ideas how I can get around this ?

topic Rolling Qty in App Development

Rolling Qty

Re: Rolling Qty