create legend with trendline

[Anonymous]

Hey,

I would like to add a legend to my line chart, which consists of a time series and its trend.

Could you help me with this issue?

Many thanks in advance!

[oknotsen]

You posted this question in the wrong forum.

Could you tell us if you are asking this for QlikView or Qlik Sense, so we can move it to a more fitting forum?

[Anonymous]

My question refers to QlikView.

Thank you for moving my question to the right forum!

[balabhaskarqlik]

Can you try this:

http://livingqlikview.com/how-to-reference-line-linear-trend-qlik-sense/

[balabhaskarqlik]

Can you try this Expression:

The expression below needs to be used and calculated as a new measure

linest_m(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)*   only({1}OrderDate)+linest_b(total aggr(if(sum(Sales),sum(Sales)),OrderDate),OrderDate)

Or may be some other extensions.

[Anonymous]

My trend line is not linear, its a polynom.

I tried to implement the trend line as a new measure.

Unfortunately, it didn't work.

[Anonymous · Accepted solution]

I just added textboxes and grouped them with the linechart.

That solution works for me just fine.

Thanks anyway!

[Frank_Hartmann]

see attached file

hope this helps

[jmvilaplanap]

Why you don't check the Trendline option?

[Anonymous]

Thats what I did.

But the question was how to add a legend to the linechart, where it says blue is for gdp and red for the trendline. Only GDP is displayed in the linechart.