topic Re: peek - previus ?? in App Development

peek - previus ??

AlejandroJuarez — Fri, 01 Dec 2023 18:06:33 GMT

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

Re: peek - previus ??

PrashantSangle — Sat, 02 Dec 2023 09:09:30 GMT

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/InterRecordFunctions/above.htm#:~:text=Above()%20evaluates%20an%20expression,being%20the%20row%20directly%20above.

for back-end use Peek()

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Peek.htm#:~:text=Peek()%20returns%20the%20value,loaded%20record%20will%20be%20used.

See example from both help doc.

Regards,

Prashant Sangle

Re: peek - previus ??

sidhiq91 — Sat, 02 Dec 2023 15:30:34 GMT

@AlejandroJuarez Could you please elaborate on your requirement?

Re: peek - previus ??

AlejandroJuarez — Sat, 02 Dec 2023 19:08:58 GMT

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

Re: peek - previus ??

AlejandroJuarez — Sun, 03 Dec 2023 04:18:13 GMT

qvd