topic Re: Reference Line on Coordinates in QlikView

Reference Line on Coordinates

Thu, 16 May 2013 22:03:31 GMT

Hi everyone!

I'm trying to draw a reference line where I set the point on the x-axis and it goes up and meets the corresponding point on the y axis. For instance, imagine an x axis of "number of days" and y axis of "number of items produced". If I set the x axis to 35 days, I want it to meet where the y-axis says 20 items produced.

Hopefully that is clear. Thanks!

Re: Reference Line on Coordinates

Thu, 16 May 2013 22:10:36 GMT

I'm not entirely sure of what you need, but perhaps you can accomplish this creating an expression with the following condition:

if([number of days] = 35,20,0)

If that doesn't work, perhaps try posting a sample qvw and people may have an easier time fining a solution.

Hope that helps,

Matt

Re: Reference Line on Coordinates

Thu, 16 May 2013 22:20:13 GMT

Hi Matt,

Thanks for your help. That doesn't exactly meet what I'm looking for. I have attached a chart below. As you can see, the reference lines are currently at x=45 and x=60 but go all the way to the top of the chart. I want them to hit at the y-coordinates that correspond to x=45 and x=60. Does that make more sense?

Re: Reference Line on Coordinates

Thu, 16 May 2013 22:43:22 GMT

Hi,

I've added them as expressions (you may be able to use the same set to create a reference line too) and the lines now end where x and y meet.

Let me know if that works for you.

Re: Reference Line on Coordinates

Fri, 17 May 2013 02:55:38 GMT

Thanks! That was a really helpful start. I tried to finish off the chart by adding the horizontal reference lines at y=380 and y = 395 but the lines don't stop at the x=45 and x=60 coordinates. I did this by adding in reference lines under the presentation tab... Is there a way to get them to intersect by writing an expression?

Re: Reference Line on Coordinates

Fri, 17 May 2013 13:42:21 GMT

Hi,

I added two more expressions to meet this requirement.

Let me know if that works.

Best,

Matt

Re: Reference Line on Coordinates

Fri, 17 May 2013 14:53:24 GMT

Thanks! Well, I was hoping the line would hit the y-axis at y=380 and y=395 as those the are corresponding coordinates to x=45 and x=60. Instead, it is hitting the x=380 and x=395 values. I tried modifying your expressions but no luck. Any ideas?

Thank you!

Re: Reference Line on Coordinates

Fri, 17 May 2013 15:55:56 GMT

Ok, y references now begin from y axis and stop at corresponding x coordinate. Think that's what you wanted.

Let me know if that works.

Matt

Re: Reference Line on Coordinates

Fri, 17 May 2013 16:04:31 GMT

That's it exactly!!! Thanks!