We are trying to configure Qlik to help us pick a most-recent date when a value was exceeded.
I'm attaching a sample dataset.
In this data, we are interested in values that exceed 0.015.
For the most-recent (latest date) that a value of 0.015 was exceeded, we want to display the date and the value.
The correct answer is 2004-12-31, with the value of 0.02.
How can I display the date and value associated with that date, either by using the load script to create a latest date, or by configuring a measure to do this? I think I'd prefer to handle it in the load script.
