topic Re: Cumulative Sum future in QlikView

Cumulative Sum future

Thu, 03 Jul 2014 17:01:53 GMT

Hi,

It's possible to have a table like this:

Year	Profit %	Value
2014	10	1000,00
2015	20	???
2016	10	???
2017	10	???
2018	30	???
2019	15	???

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:

Year	Profit %	Value
2014	10	1000,00
2015	20	1100,00
2016	10	1320,00
2017	10	1452,00
2018	30	1597,20
2019	15	2076,36

Thanks,

GM.

Re: Cumulative Sum future

Gysbert_Wassenaar — Fri, 04 Jul 2014 08:54:11 GMT

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
];

Re: Cumulative Sum future

alexandros17 — Fri, 04 Jul 2014 08:58:55 GMT

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