topic Re: Adding a constant straight line to a chart? in QlikView

Adding a constant straight line to a chart?

Tue, 11 Jun 2013 14:23:40 GMT

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.

Re: Adding a constant straight line to a chart?

Clever_Anjos — Tue, 11 Jun 2013 14:28:23 GMT

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

Re: Adding a constant straight line to a chart?

Wed, 12 Jun 2013 14:40:35 GMT

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.

Re: Adding a constant straight line to a chart?

rustyfishbones — Wed, 12 Jun 2013 14:46:30 GMT

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

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

Re: Adding a constant straight line to a chart?

Wed, 12 Jun 2013 14:52:00 GMT

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

Re: Adding a constant straight line to a chart?

Wed, 12 Jun 2013 15:27:18 GMT

Found the solution. I used:

sum(TOTAL $(vMetricSelectorLTHA))