Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

How get the right value in Ingoing balance

 

Hi people!

I really need some help here.      

below is an example of what i want to achieve.

   

yearIngoing Balancerecoded amount
2017600100
2016800-200
2015500300
2014800-300
2013300500
2012200100
20110200

 

I want to sum the recorded amount of all the previous years and put in the present years "Ingoing balance" column (so for year 2017, sum recorded amount until 2016), BUT i do not want the values in this column to be affected by any selections....

 

I have tried Set analysis but I did not get it to work properly.

 

Here is what I have tried so fara:

 

              RangeSum(above(Sum({1<[Year]>} [Recorded amount]), 1, [Year] ))

 

I think would like to make the entire expression a set...  

I am super grateful for any suggestions!

Thanks!