Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Not applicable
Author

Found the solution.  I used:

sum(TOTAL $(vMetricSelectorLTHA))

View solution in original post

5 Replies
Clever_Anjos
Employee
Employee

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

Not applicable
Author

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.

rustyfishbones
Master II
Master II

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

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

Not applicable
Author

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

Not applicable
Author

Found the solution.  I used:

sum(TOTAL $(vMetricSelectorLTHA))