- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to create a accumulated results by product in a straight table?
Dear Colleagues, I'm trying to get a accumulated results that depends on the Product in a straight table
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.
I appreciate if somebody can give a good idea to share. I have added the Qlikview as example enclosed.
Thanks
Leandro
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Aggr(RangeSum(Above(sum(Incomming)-sum(Consumption), 0, RowNo())), Product, Day)
Also, make sure your Day is read as date field
Date#(Day, 'DD-MMM') as Day,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Aggr(RangeSum(Above(sum(Incomming)-sum(Consumption), 0, RowNo())), Product, Day)
Also, make sure your Day is read as date field
Date#(Day, 'DD-MMM') as Day,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sunny is here, I can rest...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oleg the kind of explanation you provide is unmatched (may be John can match it, but certainly not me). So, you inputs are always valuable.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Sunny, I'm trying to use the same function but adding also an expression in the accumulation. What is your suggestion to have the same solution with dimensions + expression in the accumulated sum?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Would you be able to may be create a new thread and provide more explanation (and a sample if possible) as to what is going on and may be one of us here might be able to help you out better?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Sunny, I have created a new topic, please see below = How to create a accumulated results by product in a straight table from expression?