Discussion Board for collaboration related to QlikView App Development.
I am trying to dynamically work out the current rent a tenant should be paying based upon a rent history table and a variable called vReportDate that is set by a calendar object.
I can setup Set analysis to provide the tenants linked MAX rent history table fields, but I want to be able to bring back the RentAmout for MAX value of the startDate before or equal to my vReportDate
vReportDate = 16/04//2020
Rent History Table:
The values I need to bring back would be:
Any help would be much appreciated.
Hi, you can use this expression:
View solution in original post