Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Adding reference line - Line Chart

What are the steps of adding vertical reference lines in a line chart? Please help..!!

1 Solution

Accepted Solutions

Re: Adding reference line - Line Chart

Hi,

maybe using a combo chart instead of a line chart and creating a narrow bar at a specific date using some flag.

hope this helps

regards

Marco

View solution in original post

8 Replies
morganaaron
Valued Contributor

Re: Adding reference line - Line Chart

As far as I know, you can only use the inbuilt reference line function when your x axis is continuous.

Go to Axes and on the bottom half of the options, tick continuous for your axis (assuming you want it to be..!)

Then in the Presentation tab you can choose reference line, add one on the Continuous X Axis and give it an expression like =5 for example, which on a continuous scale from 1-20 would create a reference line at 5.

Highlighted
Partner
Partner

Re: Adding reference line - Line Chart

Hello,

In presentation tab, click on add a reference line.
You can put an expression or a value.

Not applicable

Re: Adding reference line - Line Chart

Thanks for the reply. I'm getting continuous x option as disabled. Can you tell me the reason possibly behind it?

Capture.PNG

Not applicable

Re: Adding reference line - Line Chart

Thanks for the reply. I'm getting continuous x option as disabled. Can you tell me the reason possibly behind it?

Capture.PNG

Re: Adding reference line - Line Chart

Hi,

vertical reference lines are only available for continuous dimension axes, so you have to set your dimension axis properties accordingly:

QlikCommunity_Thread_145641_Pic1.JPG

QlikCommunity_Thread_145641_Pic2.JPG

QlikCommunity_Thread_145641_Pic3.JPG

QlikCommunity_Thread_145641_Pic4.JPG

hope this helps

regards

Marco

Not applicable

Re: Adding reference line - Line Chart

Thank you so much for the help. But I can't make my dimension axis continuous as I'm representing dates as my dimension which are take from an excel sheet and are not continuous.

Capture.PNG

Is it still possible to define some vertical reference lines at some of the selected dates?

Thanks and Regards

Nishant

Re: Adding reference line - Line Chart

Hi,

maybe using a combo chart instead of a line chart and creating a narrow bar at a specific date using some flag.

hope this helps

regards

Marco

View solution in original post

Re: Adding reference line - Line Chart

marcowedel

I need same in Qliksense, Do we have any work around to check? If possible, Can you share V1 in sense (QVF).

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)