topic Peek on first row in subset in App Development

Peek on first row in subset

stabben23 — Mon, 27 Jun 2022 08:51:33 GMT

Hi, I want to use first row in a subset of data as comparison.

This is how I have script right now:

if(peek(Key)= Key, DateComparison - peek(StartDateComparison,0),0) as Days

But peek(StartDateComparison,0) will always find First row in table, not first row in subset (Bold Row).

So what I want is that all dates should for all Key should be Compared with StartDateComparison

Re: Peek on first row in subset

MayilVahanan — Mon, 27 Jun 2022 09:08:24 GMT

Try like below

if(peek(Key)= Key, peek(StartDateComparison),StartDateComparison) as StartDateComparison

By using above script, we can able to see "StartDateComparison" values in all rows. Then, u can simply sub those 2 fields to get the "days".

Re: Peek on first row in subset

stabben23 — Mon, 27 Jun 2022 09:24:22 GMT

Hi @MayilVahanan

That´s a great input, I will test this in my script.

Re: Peek on first row in subset

stabben23 — Mon, 27 Jun 2022 09:42:08 GMT

Brilliant @MayilVahanan this was exactly what I needed.

Thanks!