topic Full Accumulation with Dimension in QlikView https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705178#M1057287 <HTML><HEAD></HEAD><BODY><P>Does anyone know how to fix below? </P><P></P><P>I am using a simple sum function to calculate the expression. I have chosen to use full accumulation to see this information over time and have added a dimension. </P><P></P><P>However, when I add a dimension, it looks like it doesn't calculate back if the dimension didn't exist.... Please see images below. </P><P></P><P>Does anyone know how to fix this? The chart with the dimensions should have the same overall values as the chart below (without dimensions). </P></BODY></HTML> Fri, 10 Oct 2014 22:38:21 GMT 2014-10-10T22:38:21Z Full Accumulation with Dimension https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705178#M1057287 <HTML><HEAD></HEAD><BODY><P>Does anyone know how to fix below? </P><P></P><P>I am using a simple sum function to calculate the expression. I have chosen to use full accumulation to see this information over time and have added a dimension. </P><P></P><P>However, when I add a dimension, it looks like it doesn't calculate back if the dimension didn't exist.... Please see images below. </P><P></P><P>Does anyone know how to fix this? The chart with the dimensions should have the same overall values as the chart below (without dimensions). </P></BODY></HTML> Fri, 10 Oct 2014 22:38:21 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705178#M1057287 2014-10-10T22:38:21Z Re: Full Accumulation with Dimension https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705179#M1057289 <HTML><HEAD></HEAD><BODY><P>Please provide some sample data....</P></BODY></HTML> Sat, 11 Oct 2014 07:49:59 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705179#M1057289 MK_QSL 2014-10-11T07:49:59Z Re: Full Accumulation with Dimension https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705180#M1057291 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Very sorry for my late response. </P><P></P><P>I think the values are Null... or the data stops coming in for the specific field... I have included 3 charts. </P><P></P><P>The bar chart without the dimension is how it should look. Do I need to make changes in the script (replacing Null values with numerical value 0) or is this something I can do on the front end UI? </P><P></P><P><IMG alt="Image1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69126_Image1.PNG.png" style="width: 620px; height: 266px;" /><IMG alt="Image2.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69127_Image2.PNG.png" style="width: 620px; height: 267px;" /><IMG alt="Image3.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/69143_Image3.PNG.png" style="width: 620px; height: 140px;" /></P></BODY></HTML> Thu, 16 Oct 2014 20:42:56 GMT https://community.qlik.com/t5/QlikView/Full-Accumulation-with-Dimension/m-p/705180#M1057291 2014-10-16T20:42:56Z