topic RangeSum in Script in QlikView

RangeSum in Script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello! I would appreciate if someone can help me on this...

I have an expression in pivot table that I would like to put it in script :

= rangesum(before(total sum(if(SalesQty >0, SalesQty )),0,NoOfColumns(TOTAL)))

my table is showm below :

Rangesum:
NoConcatenate
load
Product,

Location,

Company,,
WeekDate,

alesQty,

f(Product = previous(Product]), rangesum(SalesQty, peek(Sales_Accu)),SalesQty) as Sales_Accu,

Resident demand;

But the output doesn't come out right. Below is my expected out put in yellow shade ::

Pls. advise...Btw, my expression in pivot table works perfectly.

Thank you in advance.

aarkay29 — Fri, 10 Mar 2017 03:20:07 GMT

Try using Order by

load
Product,

Location,

Company,
WeekDate,

SalesQty,

f(Product = previous(Product]), rangesum(SalesQty, peek(Sales_Accu)),SalesQty) as Sales_Accu,

Resident demand

Order By

Product,

Location,

Company,
WeekDate ASC;

Anonymous — Mon, 13 Mar 2017 18:59:07 GMT

Hi! Aar,

I tried but it only work on Com A ... 1st week 03/06 Com B and C has different value ...not sure where they come from.

aarkay29 — Mon, 13 Mar 2017 19:02:41 GMT

This should work

if(Product = previous(Product]),

If(Company= previous(Company), rangesum(SalesQty, peek(Sales_Accu)),SalesQty),SalesQty) as Sales_Accu,

Anonymous — Mon, 13 Mar 2017 20:26:24 GMT

HI! Aar,

It still doesn't work but I added if(Location = previous(location]) and it worked now. Thank you so much.

Rgds