Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

It is Possible to add a Custom TrendLine in Qlikview Graph?

It is Possible to add a Custom TrendLine in Qlikview Graph?

I would to use a custom formula to get equation and Trendline.

Can i do it by macro for example?

4 Replies
Not applicable
Author

Hi

Have you looked at "Reference Lines" int he presentation tab of the chart, this allows you to create your own expression for the line so you should be able to create a trend line using that method.

kji
Employee
Employee

Reference lines can only give you a vertical or horizontal line at variable positions, i am assuming he wants the possiblity to input some arbitrary equation, which i don't think is possible unless you want to make a separate expression for it which might work in some cases.

Not applicable
Author

Hi Johan

You're correct, sorry about the confusion.

If the trend line is calculated according to other values already shown in the chart then why not add another expression, make it invisible and select one of the standard trend line options, this appears to work (I tried this one before replying).

Not applicable
Author

Hi, thanks for replies.

When I select the trendline in Expression Tab (for example linear) Qlikview return me a line and an equation.

Qlikview find them using an own hidden algorythm. (I Think).

I'd like to do the same process using my personal algorythm.