Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jarwitwicki
Contributor
Contributor

Rangesum with 2 dimensions in chart

hi,

I am looking for a solution

I have such sample data:

1.jpg

I made a chart with sums of cumulative function:

=RangeSum(Above(TOTAL Sum([SALES]), 0, RowNo(TOTAL)))

2.jpg

On the chart I have a sum for all the years and previous months and I want to sum up each year separately.

So, for example, for 2018 year (Q1,Q2,Q3) – RangeSum – (25,45,75) and for 2017 year (15,35,55,85) on chart,

can someone help me.

1 Reply
jarwitwicki
Contributor
Contributor
Author

I searched and found a solution:

Aggr(RangeSum(Above(Sum(SALES),0,RowNo())),YEAR,QUARTER)

Who searches does not err