topic Adding a Target Line onto a graph in QlikView

Adding a Target Line onto a graph

Fri, 09 Mar 2012 10:38:18 GMT

Hi All,

I have a graph which i has a dimension of 0, 1-10, 11-20 etc. i want to put a vertical line on the graph at 56 as that is the target to be under.

Do you know how this can be done?

Thanks

Laura

Adding a Target Line onto a graph

CELAMBARASAN — Fri, 09 Mar 2012 10:46:47 GMT

Hi,

Add a reference line with the value 56.

Chart properties-->Presentation tab-->Reference lines click add.

Celambarasan

Adding a Target Line onto a graph

Fri, 09 Mar 2012 10:52:02 GMT

i have tried that but it goes horizontal and i want it vertical

Re: Adding a Target Line onto a graph

jagan — Fri, 09 Mar 2012 11:00:42 GMT

Hi,

Can you attach the sample or screenshot. Check the attachment, hope it helps you.

Regards,

Jagan.

Adding a Target Line onto a graph

Fri, 09 Mar 2012 11:04:06 GMT

The problem is in the reference line i need to select continous x but it is blank out.

Adding a Target Line onto a graph

Fri, 09 Mar 2012 11:14:14 GMT

this is want happens which i do exactly the same thing as you advised. i want the red line to be vertical where you can see on the x axis it says 56.

Re: Adding a Target Line onto a graph

jagan — Fri, 09 Mar 2012 11:22:30 GMT

Hi,

You will get the Reference Line, based on the expression, if the expression values is on Y axis then you will get horizontally. If your expression is on X axis then you will get the Reference line vertically. That is why you can see the option Continuous X option is disabled. Since you have calculated values(Expression) is on Y.

Regards,

Jagan.

Re: Adding a Target Line onto a graph

Fri, 09 Mar 2012 11:36:18 GMT

What do i need to right in the expression box to be able to enable the x axis?