topic Accumulation with null values in QlikView https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141727#M21335 <HTML><HEAD></HEAD><BODY><P>In addition to Yves suggestion, I also had to <EM>check</EM> "Show All Values" for the YearQtr dimension to get the desired behavior. I'm using 8.5.</P></BODY></HTML> Sun, 26 Apr 2009 18:53:25 GMT 2009-04-26T18:53:25Z Accumulation with null values https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141723#M21331 <HTML><HEAD></HEAD><BODY><P>If you turn on full accumulation on a chart and an expression does not have a value in the maximum value of the first dimension, the accumulation reverts back to zero. For example, open the consulting services sample, go to the Consultants tab, add a list box for the "Consulting" field, select 20 and watch the animation. Only those consultants with a "20" for consulting in 2008-Q4 will have an accumulated value at the end of the animation. Is this by design?</P></BODY></HTML> Sat, 18 Apr 2009 00:52:11 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141723#M21331 2009-04-18T00:52:11Z Accumulation with null values https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141724#M21332 <HTML><HEAD></HEAD><BODY><P>To get around this, use the following expression:</P><P>rangesum(above(ChartFieldName,1,rowno()))</P><P>Look at the documentation for rowno() and noofrows() to suit your situation.</P><P>-Jay</P></BODY></HTML> Sun, 26 Apr 2009 17:20:48 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141724#M21332 2009-04-26T17:20:48Z Accumulation with null values https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141725#M21333 <HTML><HEAD></HEAD><BODY><P>To change default behaviour (by design), <B>uncheck</B> "suppress null values" and "suppress missing values" in presentation tab.</P></BODY></HTML> Sun, 26 Apr 2009 18:04:22 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141725#M21333 yblake 2009-04-26T18:04:22Z Accumulation with null values https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141726#M21334 <HTML><HEAD></HEAD><BODY><P>I answered too quickly, sorry.</P></BODY></HTML> Sun, 26 Apr 2009 18:21:21 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141726#M21334 2009-04-26T18:21:21Z Accumulation with null values https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141727#M21335 <HTML><HEAD></HEAD><BODY><P>In addition to Yves suggestion, I also had to <EM>check</EM> "Show All Values" for the YearQtr dimension to get the desired behavior. I'm using 8.5.</P></BODY></HTML> Sun, 26 Apr 2009 18:53:25 GMT https://community.qlik.com/t5/QlikView/Accumulation-with-null-values/m-p/141727#M21335 2009-04-26T18:53:25Z