How to create a accumulated results by product in a straight table from expression?

[#1]

Dear Colleagues, I'm trying to get a accumulated results that depends on the Product in a straight table but based on expression and not dimension.

Please see below one table with the example of expected results (last column)

I have tried to use above and it stop to accumulated when the week change. For RangeSum it accumulate all the period and not by product and the problem it doesnt work for expression.

I appreciate if somebody can give a good idea to share. I have added the Qlikview as example enclosed.

Thanks
Leandro

[sergio0592]

And if you try with checking Full accumulation?

[antoniotiman]

Hi Leandro,

may be

Aggr(RangeSum(Above(sum(Incomming-Consumption),0,RowNo())),Product,Day)

Regards,

Antonio

[#4]

Not really because I have a different product and day to be accumulated

[#5]

Dear Antonio, I'm trying to find a solution to accumulate a calculated expression. I would like to use the expression, since it depends on several other columns and this one should accumulate with other dimensions.

Do you believe there is any way to do in this way?

[sunny_talwar]

What antoniotiman‌ provided is used an expression (and not a calculated dimension). This is the only way to do this, unless you can make changes in your script and implement The As-Of Table

[sunny_talwar]

Check the attached