topic Re: Trendlines in Qlikview in QlikView

Trendlines in Qlikview

anjali0108 — Tue, 29 May 2018 09:56:15 GMT

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,.

Re: Trendlines in Qlikview

tresB — Tue, 29 May 2018 10:39:12 GMT

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.

Re: Trendlines in Qlikview

Frank_Hartmann — Tue, 29 May 2018 11:54:14 GMT

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

Re: Trendlines in Qlikview

qlikviewwizard — Tue, 29 May 2018 13:35:40 GMT

Hi,

Check this demo app. Hope this will help you.

Download from here: Qlik Demos