I am trying to use Dynamic Update to update a field in my table in a qvw. I want the field to be updated to 1 under particular circumstances. I've created a button and applied the action but it doesn't work.
The idea is that when a user selects the max date in the calendar object, the variable varMaxDate is updated with that date. This then updates the chart which only shows records up to and including that date. However, what I want the dynamic update to do is to select the max record by date within each ID (%KEY_APPLICANT in my data) so that I get the latest status before the selected date:
ID Date of Change Status
1234 1/12/14 C
1234 1/1/15 C/F
1234 1/8/15 U/F
So if I choose 1/2/15 I would only count the second record above since it is the record with the maximum date for this ID up to and including 1/12/15.
Any help would be greatly appreciated. I've attached my sample qvw for information.