loop through the rows and update the value

quser0098 — Sat, 16 Nov 2024 00:43:57 GMT

Hi devs,

Trying to update the Value column with the highest value for the product by looking into the rows between the flag 1 and -1 in the edit script. I managed to get the output in the front end using above and below functions but I would like to do this in the edit script.

*Result for the row with flag value -1 should be blank - as seen in the expected result column

Sample data laid out below and the expected result.

rowno	Product	flag	Value	Result
1	101	1	1	4
2	101	1	4	4
3	101	-1	8
4	101	1	10	10
5	101	1	2	10
6	101	1	3	10
7	101	-1	1
8	101	1	9	15
9	101	1	6	15
10	101	1	10	15
11	101	1	15	15

Re: loop through the rows and update the value

Saravanan_Desingh — Wed, 06 May 2020 19:59:16 GMT

Please check the below link.

https://community.qlik.com/t5/QlikView-App-Development/Check-each-row-value-between-flags-and-update-the-Value-field/td-p/1699408

topic loop through the rows and update the value in QlikView

loop through the rows and update the value

Re: loop through the rows and update the value