Retrieve a value from another field on another line in the same table

danny_vd_vuurst — Fri, 22 Mar 2019 13:50:32 GMT

Hi there,

I think I have a fairly simple problem to solve, but I can't find the solution.
My QVW. file consists of one table which is monthly updated with new records for that month.

Columns B:F are delivered in the source file.
I need to add column G and this should be filled with the value from column F 'reset_date' from the record line 'file_date' corresponding to the value in field 'file_date_previous_reset'.

I hoped this would work:

max({$<file_date = {"=file_date=file_date_previous_reset"}>} reset_date)

But I wouldn't be here if this works...

Any help is greatly appreciated!!

Thanks,
Danny

topic Retrieve a value from another field on another line in the same table in App Development

Retrieve a value from another field on another line in the same table