topic Start and End Date in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644023#M1088394 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Hope you can help.</P><P></P><P>The attached QVW has a user selection for Start date and End date, for this example:</P><P></P><P>please select 1/6/2014 to 1/7/2014 and push submit.</P><P>3 meters should display : AA, BB , CC</P><P>AA should display correctly</P><P>BB and CC are missing a start and an end read respectively and hence total production field is display nonsense output.&nbsp; </P><P></P><P>I want BB to display the next available Reading found on the 2/6/2014 </P><P>I want CC to display the previously available Reading found on the 30/6/2014 </P><P></P><P>The data file cannot be amended and I require a chart based solution to the issue.</P><P> your help is much appreciated .</P><P></P><P></P><P>Richard</P></BODY></HTML> Mon, 09 Jun 2014 11:22:58 GMT 2014-06-09T11:22:58Z Start and End Date in Set Analysis https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644023#M1088394 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Hope you can help.</P><P></P><P>The attached QVW has a user selection for Start date and End date, for this example:</P><P></P><P>please select 1/6/2014 to 1/7/2014 and push submit.</P><P>3 meters should display : AA, BB , CC</P><P>AA should display correctly</P><P>BB and CC are missing a start and an end read respectively and hence total production field is display nonsense output.&nbsp; </P><P></P><P>I want BB to display the next available Reading found on the 2/6/2014 </P><P>I want CC to display the previously available Reading found on the 30/6/2014 </P><P></P><P>The data file cannot be amended and I require a chart based solution to the issue.</P><P> your help is much appreciated .</P><P></P><P></P><P>Richard</P></BODY></HTML> Mon, 09 Jun 2014 11:22:58 GMT https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644023#M1088394 2014-06-09T11:22:58Z Re: Start and End Date in Set Analysis https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644024#M1088395 <HTML><HEAD></HEAD><BODY><P>Try using the firstsortedvalue function. See attached qvw</P></BODY></HTML> Mon, 09 Jun 2014 11:31:40 GMT https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644024#M1088395 Gysbert_Wassenaar 2014-06-09T11:31:40Z Re: Start and End Date in Set Analysis https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644025#M1088396 <HTML><HEAD></HEAD><BODY><P>Brilliant , thanks</P></BODY></HTML> Mon, 09 Jun 2014 13:06:21 GMT https://community.qlik.com/t5/QlikView/Start-and-End-Date-in-Set-Analysis/m-p/644025#M1088396 2014-06-09T13:06:21Z