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

Adding a constant straight line to a chart?

Hi All,

I'm trying to add a straight line to a combo chart.  My dimension is date and my expression is Removals.  I want the number of removals for the most recent date to graph a straight line throughout the entire chart. Any help would be appreciated. Thanks.

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Adding a constant straight line to a chart?

Found the solution.  I used:

sum(TOTAL $(vMetricSelectorLTHA))

View solution in original post

5 Replies
Highlighted
Employee
Employee

Re: Adding a constant straight line to a chart?

"Reference Lines" under "Presentation" tab does what you want

Highlighted
Not applicable

Re: Adding a constant straight line to a chart?

Thanks this does what I want, however the referencnes lines are on top of my line graphs and I want it to be layered below.  Any ideas? Can this be done with reference lines? Otherwise, I'll need to go back and figure a way to use expressions for this.

Highlighted
rustyfishbones
Honored Contributor II

Re: Adding a constant straight line to a chart?

Create an Expression, so if you need a line at value 1000

you create an Expression =1000 and tick the box for Line

Highlighted
Not applicable

Re: Adding a constant straight line to a chart?

I'm trying to use a field called Average.  I want the most recent average plotted as a line graph across.  Right now, I'm justgetting a single dot on 6/2013.  When I choose full accumulation it does a little bit of what I want, but only goes forward, not backwards

Highlighted
Not applicable

Re: Adding a constant straight line to a chart?

Found the solution.  I used:

sum(TOTAL $(vMetricSelectorLTHA))

View solution in original post