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

How to make set analysis for accumulation value in List Box Expression

I have a table like this:

Year     Value

2005     400

2006     500

2007     800

2008     300

2009     600

2010     900

2011     700

2012     500

How to make set analysis in List box expression to accumulate Value to be :

Year     Value

2005     400

2006     900

2007     1700

2008     2000

2009     2600

2010     3500

2011     4200

2012     4700

Can someone help me?

Thanks,

Danny

1 Solution

Accepted Solutions
Not applicable
Author

thanks,

The right expression is :

rangesum(above( Value, 0, Year))

View solution in original post

2 Replies
birubi
Contributor
Contributor

QVtest.jpg

rangesum(above( Amount,0,Year))

William

Not applicable
Author

thanks,

The right expression is :

rangesum(above( Value, 0, Year))