topic Pivot Table and Linear Trend Nature in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-and-Linear-Trend-Nature/m-p/166774#M589184 <HTML><HEAD></HEAD><BODY><P>Is it possible to have the nature of the prior 3 months' linear trend either up, down or flat based on predefined limits put into a pivot table's expression as an image or text? I guess a positive slope (m) would mean trending up, and a negative slope (m) meaning trending down.</P><P>I can load the image, but how to notate the nature of the trend which may be trending up, down or flat. What would that expression look like I wonder? I do run into pitfalls where a negative slope still results in trend going upwards. any mathematicians in the forum?</P><P>anyone try something like this before?</P></BODY></HTML> Thu, 27 May 2010 04:49:17 GMT avastani 2010-05-27T04:49:17Z Pivot Table and Linear Trend Nature https://community.qlik.com/t5/QlikView/Pivot-Table-and-Linear-Trend-Nature/m-p/166774#M589184 <HTML><HEAD></HEAD><BODY><P>Is it possible to have the nature of the prior 3 months' linear trend either up, down or flat based on predefined limits put into a pivot table's expression as an image or text? I guess a positive slope (m) would mean trending up, and a negative slope (m) meaning trending down.</P><P>I can load the image, but how to notate the nature of the trend which may be trending up, down or flat. What would that expression look like I wonder? I do run into pitfalls where a negative slope still results in trend going upwards. any mathematicians in the forum?</P><P>anyone try something like this before?</P></BODY></HTML> Thu, 27 May 2010 04:49:17 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-and-Linear-Trend-Nature/m-p/166774#M589184 avastani 2010-05-27T04:49:17Z