Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
Not applicable

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

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.

Highlighted
Employee
Employee

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

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.

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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.