topic Re: Range sum with dimesion in QlikView https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895076#M1016674 <HTML><HEAD></HEAD><BODY><P>Yes, looks like there are Cost records that are not associated with any Category1 value.</P></BODY></HTML> Fri, 10 Apr 2015 18:20:15 GMT Anonymous 2015-04-10T18:20:15Z Range sum with dimesion https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895074#M1016669 <HTML><HEAD></HEAD><BODY><P>Can anyone help me? </P><P></P><P>I have two graphs. One is a full accumulation (not using the full accumulation check box) with one dimension (time) </P><P></P><P>The other graph is the same except I have added an additional dimension. </P><P></P><P>Formula 1: rangesum(above(sum({$&lt;$(EstimateA)&gt;}Cost)/1000,0,100)) -- Correct $31.4M</P><P>Dimension: Time</P><P></P><P>Formula 2: rangesum(above(sum({$&lt;$(EstimateA)&gt;}Cost)/1000,0,100)) -- Not correct $29.6M</P><P>Dimension: Time</P><P>Dimension: Category1</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">This isn't taking into consideration the additional dimension</SPAN></P></BODY></HTML> Fri, 10 Apr 2015 15:33:02 GMT https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895074#M1016669 2015-04-10T15:33:02Z Re: Range sum with dimesion https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895075#M1016672 <HTML><HEAD></HEAD><BODY><P>do you have "Suppress when Value is Null" selected for either dimension in your second chart? otherwise, can you attach a sample qvw?</P></BODY></HTML> Fri, 10 Apr 2015 18:04:26 GMT https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895075#M1016672 Anonymous 2015-04-10T18:04:26Z Re: Range sum with dimesion https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895076#M1016674 <HTML><HEAD></HEAD><BODY><P>Yes, looks like there are Cost records that are not associated with any Category1 value.</P></BODY></HTML> Fri, 10 Apr 2015 18:20:15 GMT https://community.qlik.com/t5/QlikView/Range-sum-with-dimesion/m-p/895076#M1016674 Anonymous 2015-04-10T18:20:15Z