topic Calculate Cumulative Graph in QlikView https://community.qlik.com/t5/QlikView/Calculate-Cumulative-Graph/m-p/241733#M588645 <HTML><HEAD></HEAD><BODY><P>I am struggling with a cumulative expenditure chart (see below).</P><P>Essentially the chart consists of:</P><P><STRONG>Dimension1:</STRONG> [Date] (continuous X axis)<BR /><STRONG>Dimension2:</STRONG> DimensionX<BR /><STRONG>Expression1:</STRONG> sum(AmountGBP)</P><P>The chart is set to full aggregation however I cannot get it to calculate values beyond the date of last expenditure for each dimnsion. Beyond this point the series disappears, when I want it to continue to the same value.</P><P>Any suggestions? I have played around with rangesum and other functions but cannot get it to work.</P><P>Many Thanks.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3741_sourceID:3741" /></P></BODY></HTML> Tue, 08 Mar 2011 14:07:58 GMT 2011-03-08T14:07:58Z Calculate Cumulative Graph https://community.qlik.com/t5/QlikView/Calculate-Cumulative-Graph/m-p/241733#M588645 <HTML><HEAD></HEAD><BODY><P>I am struggling with a cumulative expenditure chart (see below).</P><P>Essentially the chart consists of:</P><P><STRONG>Dimension1:</STRONG> [Date] (continuous X axis)<BR /><STRONG>Dimension2:</STRONG> DimensionX<BR /><STRONG>Expression1:</STRONG> sum(AmountGBP)</P><P>The chart is set to full aggregation however I cannot get it to calculate values beyond the date of last expenditure for each dimnsion. Beyond this point the series disappears, when I want it to continue to the same value.</P><P>Any suggestions? I have played around with rangesum and other functions but cannot get it to work.</P><P>Many Thanks.</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3741_sourceID:3741" /></P></BODY></HTML> Tue, 08 Mar 2011 14:07:58 GMT https://community.qlik.com/t5/QlikView/Calculate-Cumulative-Graph/m-p/241733#M588645 2011-03-08T14:07:58Z