Discussion board where members can get started with Qlik Sense.
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
Revenue from Year 2012 vintage 2012
Revenue from Year 2013 vintage 2012
Revenue from Year 2014 vintage 2012
I included the equations that create the cumulative sales column.
May be like this:
Aggr(RangeSum(Above(Sum(Revenue), 0, RowNo())), Vintage, Year)
Attaching a sample for review