Trendlines in Qlikview

[anjali0108]

Hi,

There is one requirement in my account where they want to see a trendline(not static) for the graph plotted to see whether the performance is better or weaker and they are comparing that with the trendlines of the tableau.

Kindly let me know what shall be done to add a trendline in qlikview that makes sense to the user.

I have also seen an option of trendlines at the bottom left of expressions tab in charts. let me know if that only is the best way to show trendlines in QlikView.

Thanks in advance,.

[tresesco]

Yes, that is the option (default). However, you can write your own logic (expression) for a line and that can be depicted as trend, may be.

[Frank_Hartmann]

if you want to write the trend as expression, use the formula like this:

Linest_m(Total Aggr(Y1,X1), X1) * X1 + Linest_b(Total Aggr(Y1,X1), X1)

hope this helps

[qlikviewwizard]

Hi,

Check this demo app. Hope this will help you.

Download from here: Qlik Demos