Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
anjali0108
Partner - Creator III
Partner - Creator III

Trendlines in Qlikview

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

3 Replies
tresesco
MVP
MVP

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
Master II
Master II

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
Master II
Master II

Hi,

Check this demo app. Hope this will help you.

Download from here: Qlik Demos

Capture.JPG