topic How to make set analysis for accumulation value in List Box Expression in QlikView https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367655#M136707 <HTML><HEAD></HEAD><BODY><P>thanks,</P><P></P><P>The right expression is :</P><P>rangesum(above( Value, 0, Year))</P></BODY></HTML> Mon, 26 Mar 2012 02:28:45 GMT 2012-03-26T02:28:45Z How to make set analysis for accumulation value in List Box Expression https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367653#M136705 <HTML><HEAD></HEAD><BODY><P>I have a table like this:</P><P></P><P></P><P></P><P>Year&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>2005&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P>2006&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P>2007&nbsp;&nbsp;&nbsp;&nbsp; 800</P><P>2008&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>2009&nbsp;&nbsp;&nbsp;&nbsp; 600</P><P>2010&nbsp;&nbsp;&nbsp;&nbsp; 900</P><P>2011&nbsp;&nbsp;&nbsp;&nbsp; 700</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P></P><P></P><P></P><P>How to make set analysis in List box expression to accumulate Value to be :</P><P></P><P>Year&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>2005&nbsp;&nbsp;&nbsp;&nbsp; 400</P><P>2006&nbsp;&nbsp;&nbsp;&nbsp; 900</P><P>2007&nbsp;&nbsp;&nbsp;&nbsp; 1700</P><P>2008&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>2009&nbsp;&nbsp;&nbsp;&nbsp; 2600</P><P>2010&nbsp;&nbsp;&nbsp;&nbsp; 3500</P><P>2011&nbsp;&nbsp;&nbsp;&nbsp; 4200</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp; 4700</P><P></P><P>Can someone help me?</P><P>Thanks,</P><P>Danny</P></BODY></HTML> Sat, 24 Mar 2012 06:47:49 GMT https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367653#M136705 2012-03-24T06:47:49Z How to make set analysis for accumulation value in List Box Expression https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367654#M136706 <HTML><HEAD></HEAD><BODY><P><IMG alt="QVtest.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/12398_QVtest.jpg" /></P><P></P><P>rangesum(above( Amount,0,Year))</P><P></P><P>William</P></BODY></HTML> Sat, 24 Mar 2012 10:51:31 GMT https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367654#M136706 birubi 2012-03-24T10:51:31Z How to make set analysis for accumulation value in List Box Expression https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367655#M136707 <HTML><HEAD></HEAD><BODY><P>thanks,</P><P></P><P>The right expression is :</P><P>rangesum(above( Value, 0, Year))</P></BODY></HTML> Mon, 26 Mar 2012 02:28:45 GMT https://community.qlik.com/t5/QlikView/How-to-make-set-analysis-for-accumulation-value-in-List-Box/m-p/367655#M136707 2012-03-26T02:28:45Z