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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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)