Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Dynamic Update and maximum record


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.



0 Replies