topic Re: first instance of negative value based on selection of particular date. in QlikView https://community.qlik.com/t5/QlikView/first-instance-of-negative-value-based-on-selection-of/m-p/813198#M286907 <HTML><HEAD></HEAD><BODY><P>Perhaps with FirstSortedValue({&lt;Value={'&lt;0'},Date={'&gt;$(=max(Date))'}&gt;}Value , Date)</P><P>See attached qvw.</P></BODY></HTML> Tue, 03 Feb 2015 11:32:01 GMT Gysbert_Wassenaar 2015-02-03T11:32:01Z first instance of negative value based on selection of particular date. https://community.qlik.com/t5/QlikView/first-instance-of-negative-value-based-on-selection-of/m-p/813197#M286906 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Below is the data table containing Date and Value.</P><P></P><P><STRONG>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</STRONG></P><P>30-Apr-14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>31-May-14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -3500</P><P>30-Jun-14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000</P><P>31-Jul-14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -5000</P><P>31-Aug-14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -8000</P><P>30-Sep-14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -6700</P><P>31-Oct -14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9000</P><P></P><P>Need your help in getting the first instance of negative value based on selection of particular date. </P><P></P><P>For eg.:</P><P>When 30-Apr-14 is selected, it should show the value -3500 as it is the first instance of negative value after 30-Apr-14. When 31-Jul-14 is selected, -8000 should be shown, etc.</P><P></P><P>How can this be achieved inside an expression?</P><P></P><P>Thanks in advnce.</P></BODY></HTML> Tue, 03 Feb 2015 10:04:31 GMT https://community.qlik.com/t5/QlikView/first-instance-of-negative-value-based-on-selection-of/m-p/813197#M286906 sunilkumarqv 2015-02-03T10:04:31Z Re: first instance of negative value based on selection of particular date. https://community.qlik.com/t5/QlikView/first-instance-of-negative-value-based-on-selection-of/m-p/813198#M286907 <HTML><HEAD></HEAD><BODY><P>Perhaps with FirstSortedValue({&lt;Value={'&lt;0'},Date={'&gt;$(=max(Date))'}&gt;}Value , Date)</P><P>See attached qvw.</P></BODY></HTML> Tue, 03 Feb 2015 11:32:01 GMT https://community.qlik.com/t5/QlikView/first-instance-of-negative-value-based-on-selection-of/m-p/813198#M286907 Gysbert_Wassenaar 2015-02-03T11:32:01Z