Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of previous data value based on Properties

I have table data like the below,

Date      Properties  Value

01-01-2012   Fridge   20

05-05-2012   Fridge   30

01-01-2012     A/C    30

02-02-2012     A/C    40

02-02-2012     TV     60

07-07-2012    Fridge 70

08-09-2012    LCD   40

30-09-2012    LCD   40

I want the result in the below

Date       Properties   Value

01-01-2012   Fridge     20

05-05-2012   Fridge     50

01-01-2012    A/C       30

02-02-2012    A/C       70

02-02-2012    TV        60

07-07-2012   Fridge   120

08-09-2012    LCD     40

30-09-2012    LCD    80

How to get this result

3 Replies
Not applicable
Author

Anyone having idea...above my question

silambarasan
Creator II
Creator II

Dimension   :   Date

                       Properties

Expression   :  sum( aggr( rangesum( above( sum(Value),0,NoOfRows()) ),Properties,Date))

silambarasan
Creator II
Creator II

Expression  : aggr(RangeSum(Above(Sum(Value),0,NoOfRows())),Category,Date)