topic Get specific values between dates in QlikView https://community.qlik.com/t5/QlikView/Get-specific-values-between-dates/m-p/982509#M959046 <HTML><HEAD></HEAD><BODY><P>Hope some one can help me.&nbsp; I have uploaded data file and .qvw so that the smart person can upload the solution.</P><P></P><P>I have stock data in date descending order, and created field called "Marker".&nbsp; In this field I have values, of which 50 represents the important line.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; For every line that has a 50, I need to get the date where the "High Price" field meets or exceed the "Exit_Price" field.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 2.&nbsp; Once I have this #1, I then need the number of days between the date found in #1 and the date on the line with the 50.</P><P></P><P>I am stuck and burned out here.&nbsp; I don't think I cant try anything, I need someone smart to give me a working model.&nbsp; Any help will be greatly appreciated.</P></BODY></HTML> Wed, 28 Oct 2015 15:48:05 GMT 2015-10-28T15:48:05Z Get specific values between dates https://community.qlik.com/t5/QlikView/Get-specific-values-between-dates/m-p/982509#M959046 <HTML><HEAD></HEAD><BODY><P>Hope some one can help me.&nbsp; I have uploaded data file and .qvw so that the smart person can upload the solution.</P><P></P><P>I have stock data in date descending order, and created field called "Marker".&nbsp; In this field I have values, of which 50 represents the important line.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 1.&nbsp; For every line that has a 50, I need to get the date where the "High Price" field meets or exceed the "Exit_Price" field.</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 2.&nbsp; Once I have this #1, I then need the number of days between the date found in #1 and the date on the line with the 50.</P><P></P><P>I am stuck and burned out here.&nbsp; I don't think I cant try anything, I need someone smart to give me a working model.&nbsp; Any help will be greatly appreciated.</P></BODY></HTML> Wed, 28 Oct 2015 15:48:05 GMT https://community.qlik.com/t5/QlikView/Get-specific-values-between-dates/m-p/982509#M959046 2015-10-28T15:48:05Z