Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
avastani
Contributor II

Pivot Table and Linear Trend Nature

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.

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?

anyone try something like this before?

Community Browser