Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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)

model.png

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

6 Replies
sergio0592
Specialist III
Specialist III

And if you try with checking Full accumulation?

antoniotiman
Master III
Master III

Hi Leandro,

may be

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

Regards,

Antonio

Not applicable
Author

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

Not applicable
Author

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