topic Get value from chart with another condition on other field in QlikView https://community.qlik.com/t5/QlikView/Get-value-from-chart-with-another-condition-on-other-field/m-p/465037#M173691 <HTML><HEAD></HEAD><BODY><P>Hello Expert,</P><P></P><P>Say we have such data:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp; Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Price</P><P>1/1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09:00&nbsp;&nbsp;&nbsp; 1</P><P>1/1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00&nbsp;&nbsp;&nbsp; 2</P><P>1/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09:00&nbsp;&nbsp;&nbsp; 3</P><P>1/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00&nbsp;&nbsp; 4</P><P></P><P>The goal is to display the initial price per day in one line chart, where the price is based on the minmium time of the day.</P><P></P><P>Say, the initial price of 1/1 is 1 and 3 for 1/2.</P><P></P><P>One more step, the initial price is the price based on maxmium time of previous day.</P><P></P><P>How to get there for both options?</P><P></P><P>Many thanks</P><P>HTC</P></BODY></HTML> Thu, 18 Apr 2013 01:42:43 GMT 2013-04-18T01:42:43Z Get value from chart with another condition on other field https://community.qlik.com/t5/QlikView/Get-value-from-chart-with-another-condition-on-other-field/m-p/465037#M173691 <HTML><HEAD></HEAD><BODY><P>Hello Expert,</P><P></P><P>Say we have such data:</P><P></P><P>Date&nbsp;&nbsp;&nbsp;&nbsp; Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Price</P><P>1/1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09:00&nbsp;&nbsp;&nbsp; 1</P><P>1/1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00&nbsp;&nbsp;&nbsp; 2</P><P>1/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09:00&nbsp;&nbsp;&nbsp; 3</P><P>1/2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10:00&nbsp;&nbsp; 4</P><P></P><P>The goal is to display the initial price per day in one line chart, where the price is based on the minmium time of the day.</P><P></P><P>Say, the initial price of 1/1 is 1 and 3 for 1/2.</P><P></P><P>One more step, the initial price is the price based on maxmium time of previous day.</P><P></P><P>How to get there for both options?</P><P></P><P>Many thanks</P><P>HTC</P></BODY></HTML> Thu, 18 Apr 2013 01:42:43 GMT https://community.qlik.com/t5/QlikView/Get-value-from-chart-with-another-condition-on-other-field/m-p/465037#M173691 2013-04-18T01:42:43Z