Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mbespartochnyy
Contributor

Reference line for a Dimension

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

1 Solution

Accepted Solutions

Re: Reference line for a Dimension

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

Capture.PNG

7 Replies

Re: Reference line for a Dimension

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

Capture.PNG

mbespartochnyy
Contributor

Re: Reference line for a Dimension

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

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

Re: Reference line for a Dimension

Don't think this is possible

flipside
Valued Contributor II

Re: Reference line for a Dimension

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

mbespartochnyy
Contributor

Re: Reference line for a Dimension

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

That's awesome

Community Browser