I have been trying find a Qlikview solution to this.
I have a situaion where I need to check to see if a record exists in the future. Specifically has a client had a followup appointment within 90 days. If a client has had an initial appointment, I need to check to see if they have had a follow up within the time frame. The same client may then come back in a year or so and go through the same process again.
In pure SQL code I would write a sub query to return the values, in this case SQL is not an option, and I am struggling to come up with a solution.