Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-03-08 09:07 AM

Calculate Cumulative Graph

I am struggling with a cumulative expenditure chart (see below).

Essentially the chart consists of:

Dimension1: [Date] (continuous X axis)
Dimension2: DimensionX
Expression1: sum(AmountGBP)

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.

Any suggestions? I have played around with rangesum and other functions but cannot get it to work.

Many Thanks.

error loading image

2,538 Views
0 Likes
0 Replies