Start and End Date in Set Analysis

[#1]

Hi

Hope you can help.

The attached QVW has a user selection for Start date and End date, for this example:

please select 1/6/2014 to 1/7/2014 and push submit.

3 meters should display : AA, BB , CC

AA should display correctly

BB and CC are missing a start and an end read respectively and hence total production field is display nonsense output. 

I want BB to display the next available Reading found on the 2/6/2014

I want CC to display the previously available Reading found on the 30/6/2014

The data file cannot be amended and I require a chart based solution to the issue.

your help is much appreciated .

Richard

[Gysbert_Wassenaar · Accepted solution]

Try using the firstsortedvalue function. See attached qvw

[#3]

Brilliant , thanks