topic Re: TrendLine values in QlikView https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401535#M804673 <HTML><HEAD></HEAD><BODY><P>Is this permutation and combination type of questions?</P></BODY></HTML> Thu, 02 Nov 2017 15:12:02 GMT MK9885 2017-11-02T15:12:02Z TrendLine values https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401534#M804672 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a requirement where we plot some data and have some set alert lines for the data in green color. I have used linear trendline for the data to fit and has some equation. I want to know the date in the future when the trendline will cross the alert low or alert high line which is in green.</P><P></P><P>How can I calculate this date in the future in qlikview ?</P><P></P><P>I am attaching a screenshot below.<IMG alt="TrendLine Date.PNG" class="jive-image image-1" src="/legacyfs/online/181867_TrendLine Date.PNG" style="height: 326px; width: 620px;" /></P><P></P><P>Any suggestions are appreciated.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401534#M804672 rajender_qlik 2020-11-25T16:16:04Z Re: TrendLine values https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401535#M804673 <HTML><HEAD></HEAD><BODY><P>Is this permutation and combination type of questions?</P></BODY></HTML> Thu, 02 Nov 2017 15:12:02 GMT https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401535#M804673 MK9885 2017-11-02T15:12:02Z Re: TrendLine values https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401536#M804674 <HTML><HEAD></HEAD><BODY><P>Type of, but its calculating the date when it will cross the alert high in the future with the equation.</P></BODY></HTML> Thu, 02 Nov 2017 15:15:21 GMT https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401536#M804674 rajender_qlik 2017-11-02T15:15:21Z Re: TrendLine values https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401537#M804675 <HTML><HEAD></HEAD><BODY><P>I'm sure i'm not the right person to answer this but by just looking at image and 'some expression' wouldn't help much either.</P><P></P><P><A href="https://community.qlikview.com/thread/168991" title="https://community.qlikview.com/thread/168991">Permutations Math | Qlik Community</A></P><P></P><P><A href="https://community.qlik.com/thread/49057">Creation of Lottery Permutations via load script</A></P><P></P><P>hopefully someone can help you and I can also learn something new.</P></BODY></HTML> Thu, 02 Nov 2017 15:21:30 GMT https://community.qlik.com/t5/QlikView/TrendLine-values/m-p/1401537#M804675 MK9885 2017-11-02T15:21:30Z