Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
interndata
Contributor II
Contributor II

create legend with trendline

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!

1 Solution

Accepted Solutions
interndata
Contributor II
Contributor II
Author

I just added textboxes and grouped them with the linechart.

That solution works for me just fine.

Thanks anyway!

View solution in original post

11 Replies
oknotsen
Master III
Master III

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?

May you live in interesting times!
interndata
Contributor II
Contributor II
Author

My question refers to QlikView.

Thank you for moving my question to the right forum!

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.

interndata
Contributor II
Contributor II
Author

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.

interndata
Contributor II
Contributor II
Author

I just added textboxes and grouped them with the linechart.

That solution works for me just fine.

Thanks anyway!

Frank_Hartmann
Master II
Master II

see attached file

hope this helps

jmvilaplanap
Specialist
Specialist

Why you don't check the Trendline option?

Capture.PNG

interndata
Contributor II
Contributor II
Author

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.