topic Re: Multiple referred lines on a graph in QlikView

Multiple referred lines on a graph

Anonymous — Thu, 29 May 2014 16:27:24 GMT

Hi everybody,

I have made the graph "a.jpg" attached.

I would like to create a referred line for each bar but i want a shorter line.

The line doesn't go across each bar but only across its referred bar. (like green lines on attached "b.jpg")

Is that possible ?

Re: Multiple referred lines on a graph

maxgro — Thu, 29 May 2014 16:50:44 GMT

I think (workaround) you can use a combo chart, add an expression and replace the line with symbols

there is a possible (it seems a bit complex) solution at

qvdesign wordpress com

QLIKVIEW WATERMARK BAR CHARTS (A BIT LIKE BULLET CHARTS..BUT NOT QUITE)

Re: Multiple referred lines on a graph

jerem1234 — Thu, 29 May 2014 16:52:12 GMT

You won't be able to use reference lines to do that kind of job. You'll probably have to change your chart to a combo chart like Massimo Grossi mentions then create an extra expression for those bars. You'll have to use a symbol instead:

Here is an example chart with dots:

There are other symbols as well, but none that match a vertical bar.

If you are insistent on the vertical bars, you may use a bar instead and then play around with the bar offset and then in the expression, you'd have to figure out how wide you would want it:

But this may add some complexity.

Hope this helps!