topic Reference line for a Dimension in QlikView

Reference line for a Dimension

mbespartochnyy — Mon, 13 Mar 2017 15:37:25 GMT

Hello community,

I'm working on a simple chart that displays seasonal average prices for an index. My dimension is a date field and expression is an average of bid and offer values. I would like to have a reference line on a chart to show when each ear starts.

For example, attached is the sample app with charts that I would like to have. The only addition that I would like to make to the chart is have a vertical reference line showing up on January 3, 2017, January 4, 2016, January 1, 2015 etc.

Does anyone know of a way to get that reference line on the chart?

Thanks in advance,

Mikhail Bespartochnyy

Re: Reference line for a Dimension

sunny_talwar — Mon, 13 Mar 2017 15:48:35 GMT

The vertical reference line is only possible when you have continuous axis. Will something like this work for you?

Re: Reference line for a Dimension

mbespartochnyy — Mon, 13 Mar 2017 15:52:40 GMT

That's exactly what I was looking for! Thanks, Sunny!

Do you know if there's a way to have the Enable X-Axis Scrollbar working with continuous axis option enabled?

Mikhail B.

Re: Reference line for a Dimension

sunny_talwar — Mon, 13 Mar 2017 15:54:37 GMT

I don't think it is possible, but I can check

Re: Reference line for a Dimension

sunny_talwar — Mon, 13 Mar 2017 16:09:34 GMT

Don't think this is possible

Re: Reference line for a Dimension

flipside — Mon, 13 Mar 2017 16:27:58 GMT

As an alternative to Sunny's suggestion, you could add a second expression like this ...

=if(Deal_Date='1/4/2016',Dual('-----------------------------------------------------------------------------------------------',0.01),'')

... tick the Values On Data Points option and set labels to display vertically (on the Presentation tab). It will only display when there's a reduced number of data points but it might work for you. Bit of a hack, though. And I haven't tested it through Accesspoint either.

I'd also look at options such as setting the line color and line styles to alternate between periods. Also, you could change to a combo chart and have an alternating background color (essentially a static bar value which changes to alternating shades at the require date points - just set the Bar and Cluster distances to zeroes).

flipside

Re: Reference line for a Dimension

mbespartochnyy — Mon, 27 Mar 2017 19:42:25 GMT

Thanks for looking into it, Sunny! I ended up simply enabling the continuous x-axis. Didn't get any complains yet.

Re: Reference line for a Dimension

sunny_talwar — Mon, 27 Mar 2017 19:43:38 GMT

That's awesome