Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nmarinelli
Partner
Partner

Rangesum / Above in Line Chart

Hi all,

I'm running into trouble presenting a cumulative sum broken down by a dimension in a line chart. 

I would like the following for "Cumulative Value". My current formula is rangesum(above(sum(Value), 0,3)), and it works in table form when you sort by Tier, and in the line chart when the primary dimension is Tier and the secondary is Month.

MonthTierValueCumulative Value

Jan

111
Feb134
Mar159
Jan277
Feb21118
Mar21331

 

However, when sorted by Month in table view (which is also the only sort available for a line char with date on the x-axis), the following happens:

MonthTierValueCumulative Value

Jan

111
Jan278
Feb133
Feb21114
Mar155
Mar21318

 

Obviously it sums the values grouping by month rather than tier. Any solutions? I'd like the cumulative values from the first table visualized in a line chart with Month on the x-axis and Tier as the dimension. Thanks.

1 Solution

Accepted Solutions
sunny_talwar

Try this

Aggr(
  RangeSum(Above(Sum(Value), 0, 3))
, Tier, Month)

View solution in original post

1 Reply
sunny_talwar

Try this

Aggr(
  RangeSum(Above(Sum(Value), 0, 3))
, Tier, Month)

View solution in original post