topic Time Series: lowest value x time in QlikView https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92541#M766340 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data in the following format:</P><P>Time&nbsp;&nbsp;&nbsp;&nbsp; Company&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 95</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 86</P><P></P><P>I'd like to show a chart with the minimum value in time, like this:</P><P>Time&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P><SPAN style="font-size: 10pt;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85</P><P></P><P>I need to calculate the lowest value considering only the ones that have the time dimension smaller than the current line.</P><P>How can I do that in Qlikview?</P><P></P><P>Thanks for you help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brunodgarcia 2020-11-25T16:16:04Z Time Series: lowest value x time https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92541#M766340 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data in the following format:</P><P>Time&nbsp;&nbsp;&nbsp;&nbsp; Company&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 95</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 86</P><P></P><P>I'd like to show a chart with the minimum value in time, like this:</P><P>Time&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P><SPAN style="font-size: 10pt;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</SPAN></P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 85</P><P></P><P>I need to calculate the lowest value considering only the ones that have the time dimension smaller than the current line.</P><P>How can I do that in Qlikview?</P><P></P><P>Thanks for you help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92541#M766340 brunodgarcia 2020-11-25T16:16:04Z Re: Time Series: lowest value x time https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92542#M766341 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>RangeMin(Above(Min(Value), 0, RowNo()))</STRONG></P></BODY></HTML> Thu, 28 Jun 2018 16:47:52 GMT https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92542#M766341 sunny_talwar 2018-06-28T16:47:52Z Re: Time Series: lowest value x time https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92543#M766342 <HTML><HEAD></HEAD><BODY><P>Perfect! Thanks a lot!</P></BODY></HTML> Thu, 28 Jun 2018 17:06:34 GMT https://community.qlik.com/t5/QlikView/Time-Series-lowest-value-x-time/m-p/92543#M766342 brunodgarcia 2018-06-28T17:06:34Z