Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
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

Re: cummulative sales set analysis

May be like this:

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

Re: cummulative sales set analysis

Attaching a sample for review

Capture.PNG