topic Re: Adding reference line - Line Chart in QlikView

Adding reference line - Line Chart

Fri, 12 Dec 2014 15:05:40 GMT

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

Re: Adding reference line - Line Chart

morganaaron — Fri, 12 Dec 2014 15:12:02 GMT

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.

Re: Adding reference line - Line Chart

yduval75 — Fri, 12 Dec 2014 15:13:11 GMT

Hello,

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

Re: Adding reference line - Line Chart

Fri, 12 Dec 2014 16:58:29 GMT

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

Re: Adding reference line - Line Chart

Fri, 12 Dec 2014 16:58:56 GMT

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

Re: Adding reference line - Line Chart

MarcoWedel — Sat, 13 Dec 2014 00:49:28 GMT

Hi,

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

hope this helps

regards

Marco

Re: Adding reference line - Line Chart

Mon, 15 Dec 2014 10:03:46 GMT

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.

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

MarcoWedel — Mon, 15 Dec 2014 11:51:10 GMT

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

Re: Adding reference line - Line Chart

Anil_Babu_Samineni — Thu, 18 Jan 2018 05:59:18 GMT

marcowedel‌

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