Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cumulative Sum future

Hi,

It's possible to have a table like this:

YearProfit %Value
2014101000,00
201520???
201610???
201710???
201830???
201915???

I have the initial value 1000 and the possible future profit in %, and i want to calculate the value for the future

for 2015 the value is 1000 + 10%=1100

for 2016 the value is 1100+20%=1320 etc etc

the complete result from excel is here:

YearProfit %Value
2014101000,00
2015201100,00
2016101320,00
2017101452,00
2018301597,20
2019152076,36

Thanks,

GM.

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

E' possibile ottenere lo stesso risultato nell'oggetto visuale (la tua tabella) attraverso l'istruzione "Above",

dagli un'occhiata e se hai bisogno di aiuto contattami. ....

Ciao

View solution in original post

2 Replies
Gysbert_Wassenaar

Perhaps like this:

LOAD

     Year,

     [Profit %],

     alt(peek(Value),Value)*alt(previous(1+[Profit %]/100),1) as Value

INLINE [

    Year, Profit %, Value

    2014, 10, 1000

    2015, 20

    2016, 10

    2017, 10

    2018, 30

    2019, 15

];


talk is cheap, supply exceeds demand
alexandros17
Partner - Champion III
Partner - Champion III

E' possibile ottenere lo stesso risultato nell'oggetto visuale (la tua tabella) attraverso l'istruzione "Above",

dagli un'occhiata e se hai bisogno di aiuto contattami. ....

Ciao