topic Re: Line Chart properties - Reference Lines in QlikView

Line Chart properties - Reference Lines

Tue, 26 Feb 2013 16:54:21 GMT

Hi,

any idea how I can make the greed dotted reference lines stop at the where the two main lines cross?

Also, do you know where I can format the reference lines lables - i.e. text direction, text position, etc?

Thanks!

Re: Line Chart properties - Reference Lines

Tue, 26 Feb 2013 20:19:57 GMT

You could try something like this, which uses an expression instead of a reference line.

Re: Line Chart properties - Reference Lines

Wed, 27 Feb 2013 08:07:35 GMT

Thanks Rebecca!

This is great - had tried something similar but didn't get the result. However, now I'm trying to replicate what you did to trace the line that goes from 38000 on x to the interception and i don't seem to be able too...

Can you help please?

Thanks again!

Linda

Re: Line Chart properties - Reference Lines

Wed, 27 Feb 2013 14:11:25 GMT

Sure. Where are you stuck?

Re: Line Chart properties - Reference Lines

Wed, 27 Feb 2013 15:08:34 GMT

Well I'm simply trying to use the same kind of expression you created to also trace a vertical dotted line that goes from 38000 on the x axis to where the the blue and red lines cross. However it just doesn't work.

I've tried all of the following but they either give me an horizontal dotted line that goes from 0 to 38000 and overlaps the x axis or they give just one dot sitting on th ex axis at Quantity 38000.

=if(sum(K+ (v*Quantity))<=2280000 and Quantity=38000,38000)

=if(sum(K+ (v*Quantity))<=2280000,38000)

=if([Costo totale]<=2280000 and Quantity=38000,38000)

=if([Costo totale]<=2280000,38000)

Any ideas?

Thanks,

Linda

Re: Line Chart properties - Reference Lines

Thu, 28 Feb 2013 18:20:40 GMT

Hi Rebecca,

Any joy with this? That would be really helpful...

Thanks!

Re: Line Chart properties - Reference Lines

Fri, 01 Mar 2013 14:24:31 GMT

I played around with it for a bit and couldn't seem to figure out how to get the vertical line to stop where we wanted it. I think you may need to call in swuehl or Gysbert for this one... sorry!!

Re: Line Chart properties - Reference Lines

Fri, 08 Mar 2013 23:09:11 GMT

What is the logic to add vertical line using expression? I cannot figure it out even after played with your sample. Thanks

Re: Line Chart properties - Reference Lines

Mon, 11 Mar 2013 06:47:11 GMT

The idea is to show visually what are the two values (on x and y) that determine the point where the two main lines cross.