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
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jeckstein
Partner
Partner

cummulative sales set analysis

I have a table that includes Range A1:C10.

Year and vintage are dimensions and Revenue is an expression

I need to create set analysis to make the cumulative Sales column. The cumulative sales should be the sales for that specific vintage by each report year. For example Cumulative Revenue for

              

                    Year 2015 Vintage 2012

Should equal:

                    Revenue from Year 2012 vintage 2012

                                                  +                                            

                    Revenue from Year 2013 vintage 2012

                                                  +

                    Revenue from Year 2014 vintage 2012

                                                  +                                                          

                    Revenue from Year 2012 vintage 2012

I included the equations that create the cumulative sales column.

ABCD
Header 1YearVintageRevenueCumulative RevenueEquation
12012

2012

1

1

C1

22013201234C1+C2
32013201355C3
420142012711

C1+C2+C4

5201420131116C3+C5

6

2014201444C6
7201520121728C1+C2+C4+C7
820152013723C3+C5+C8
9201520142024C6+C9
102015201599C10
2 Replies
sunny_talwar

May be like this:

Aggr(RangeSum(Above(Sum(Revenue), 0, RowNo())), Vintage, Year)

sunny_talwar

Attaching a sample for review

Capture.PNG