topic Re: create legend with trendline in QlikView

create legend with trendline

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: create legend with trendline

oknotsen — Fri, 07 Jul 2017 08:02:01 GMT

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?

Re: create legend with trendline

Anonymous — Fri, 07 Jul 2017 09:01:22 GMT

My question refers to QlikView.

Thank you for moving my question to the right forum!

Re: create legend with trendline

BalaBhaskar_Qlik — Fri, 07 Jul 2017 12:41:49 GMT

Can you try this:

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

Re: create legend with trendline

BalaBhaskar_Qlik — Fri, 07 Jul 2017 12:44:46 GMT

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.

Re: create legend with trendline

Anonymous — Tue, 11 Jul 2017 08:05:22 GMT

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.

Re: create legend with trendline

Anonymous — Tue, 11 Jul 2017 12:11:49 GMT

I just added textboxes and grouped them with the linechart.

That solution works for me just fine.

Thanks anyway!

Re: create legend with trendline

Frank_Hartmann — Tue, 11 Jul 2017 14:48:37 GMT

see attached file

hope this helps

Re: create legend with trendline

jmvilaplanap — Tue, 11 Jul 2017 16:28:55 GMT

Why you don't check the Trendline option?

Re: create legend with trendline

Anonymous — Wed, 12 Jul 2017 06:13:36 GMT

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.

Re: create legend with trendline

Frank_Hartmann — Wed, 12 Jul 2017 06:17:10 GMT

did you have a look into the attached solution?

Re: create legend with trendline

Anonymous — Wed, 12 Jul 2017 15:05:38 GMT

I was not able to open the attached file, since I am using QlikView Personal Edition and it restricts the possiblity to open files created by an other Personal Edition.

Nevermind. As mentioned, I am happy with the textbox solution.

Thanks anyway!