peek - previus ??

[AlejandroJuarez]

Hello, I need to calculate the new value of the cell, but I am not able to make it work, can you help me?

	A	B	C	D	E	F
1	ID	Fecha aumento	Nombre	previo_incremento	Incremento	Indice Cemep
2	40	1/2/2019	ASOCIART ART	9,9	20,0	120,0
3	41	1/9/2019	ASOCIART ART	20,0	15,0	0,0	calculate	F2+F2*E3/100
4	42	1/4/2020	ASOCIART ART	15,0	20,0	0,0
5	43	1/10/2020	ASOCIART ART	20,0	20,0	0,0
6	44	1/6/2021	ASOCIART ART	20,0	20,0	0,0
7	45	1/9/2021	ASOCIART ART	20,0	25,0	0,0
8	46	1/3/2022	ASOCIART ART	25,0	15,0	0,0
9	47	1/8/2022	ASOCIART ART	15,0	20,0	0,0
10	48	1/11/2022	ASOCIART ART	20,0	15,0	0,0
11	49	1/12/2022	ASOCIART ART	15,0	15,0	0,0
12	50	1/3/2023	ASOCIART ART	15,0	25,0	0,0
13	51	1/7/2023	ASOCIART ART	25,0	25,0	0,0
14	52	1/10/2023	ASOCIART ART	25,0	25,0	0,0

[PrashantSangle]

where you want to implement this? in front end or in back end

For Front-end use Above()

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter....

for back-end use Peek()

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor....

See example from both help doc.

Regards,

Prashant Sangle

[sidhiq91]

@AlejandroJuarez  Could you please elaborate on your requirement?

[AlejandroJuarez]

Hi  PrashantSangle

back-end ( script) 

I need to calculate index of the previous month * month increment % you have to give me a new value that will be recalculated by the record below until all the zeros are completed

- when using this

If(match(index,0), Peek(index+(index*increase%)), index) as index2 - (no working )

thank you

[AlejandroJuarez · Accepted solution]

qvd