topic TREND function in QlikView https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056709#M943766 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Hi all</SPAN></P><P><SPAN style="font-size: 12pt;">Is there a TREND function, except for the visual linear trend line in the Expression tab, which will tell me if a trend is positive or negative over a given period?</SPAN></P><P><SPAN style="font-size: 12pt;">If a trend is negative over 3 (or 4, or 5) months I would like to show a red arrow pointing down or green arrow pointing sideways or up depending on the trend direction.</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Thanks</SPAN></P></BODY></HTML> Fri, 08 Jan 2016 20:28:13 GMT jduenyas 2016-01-08T20:28:13Z TREND function https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056709#M943766 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Hi all</SPAN></P><P><SPAN style="font-size: 12pt;">Is there a TREND function, except for the visual linear trend line in the Expression tab, which will tell me if a trend is positive or negative over a given period?</SPAN></P><P><SPAN style="font-size: 12pt;">If a trend is negative over 3 (or 4, or 5) months I would like to show a red arrow pointing down or green arrow pointing sideways or up depending on the trend direction.</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Thanks</SPAN></P></BODY></HTML> Fri, 08 Jan 2016 20:28:13 GMT https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056709#M943766 jduenyas 2016-01-08T20:28:13Z Re: TREND function https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056710#M943767 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">search for</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">linest_m()</SPAN></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 08 Jan 2016 21:00:43 GMT https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056710#M943767 MarcoWedel 2016-01-08T21:00:43Z Re: TREND function https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056711#M943768 <HTML><HEAD></HEAD><BODY><P>Thanks Marco</P><P>It may help</P></BODY></HTML> Fri, 08 Jan 2016 21:10:17 GMT https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056711#M943768 jduenyas 2016-01-08T21:10:17Z Re: TREND function https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056712#M943769 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one example using this function:</P><P></P><P><IMG alt="QlikCommunity_Thread_198952_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111129_QlikCommunity_Thread_198952_Pic1.JPG" style="height: auto; width: auto;" /></P><P><IMG alt="QlikCommunity_Thread_198952_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/111130_QlikCommunity_Thread_198952_Pic2.JPG" style="height: auto; width: auto;" /></P><P><IMG alt="QlikCommunity_Thread_198952_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/111131_QlikCommunity_Thread_198952_Pic3.JPG" style="height: 419px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_198952_Pic4.JPG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/111132_QlikCommunity_Thread_198952_Pic4.JPG" style="height: 163px; width: 620px;" /></P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 08 Jan 2016 23:32:05 GMT https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056712#M943769 MarcoWedel 2016-01-08T23:32:05Z Re: TREND function https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056713#M943770 <HTML><HEAD></HEAD><BODY><P>Exactly what I was looking for!</P><P></P><P>Thanks Marco</P></BODY></HTML> Sat, 09 Jan 2016 00:40:17 GMT https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056713#M943770 jduenyas 2016-01-09T00:40:17Z Re: TREND function https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056714#M943771 <HTML><HEAD></HEAD><BODY><P>you're welcome</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sat, 09 Jan 2016 01:44:32 GMT https://community.qlik.com/t5/QlikView/TREND-function/m-p/1056714#M943771 MarcoWedel 2016-01-09T01:44:32Z