Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

How To sum continues accumulating amount in column

I would like it to be like this in pivot table;

Year,Month,amount

Yearjanfebmarchaprilmay junjulyaugetc
2013123456789
2014101112131415161718
2015192021222324252627
2016282930313233343536
2017373839404142434445

 

instead i got this:

I used this expression RangeSum(Before(Sum(Amount), 0, ColumnNo()))

yearjanfebmarchaprilmay junjulyaugetc
2013123456789
2014123456789
2015123456789
2016123456789
3 Replies
Highlighted

How is your input data set?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

assume all are 1, i just add them up per column

Highlighted
Contributor II
Contributor II

YearJanfebmarchaprmayjunjulyaugetc
2013111111111
2014111111111
2015111111111
2016111111111

 

lets assume all are 1