Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Start and End Date in Set Analysis

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try using the firstsortedvalue function. See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try using the firstsortedvalue function. See attached qvw


talk is cheap, supply exceeds demand
Not applicable
Author

Brilliant , thanks