topic Reference Line in QlikView

Reference Line

Sat, 13 Feb 2010 11:26:35 GMT

I wonder if it's possible in a scatter plot the line : Y = X to share my plot thanks to the first diagonal line.

thanks for any help

Jean-Jacques

Reference Line

Wed, 23 Feb 2011 23:19:39 GMT

Hi, does anyone know how to do a diagonal reference line in a scatter chart?

Reference Line

pover — Thu, 24 Feb 2011 01:14:39 GMT

Here are some X=Y Diagonal Lines in a Scatter Plot. I'm going to keep working on it, but right now for it to work you need to have a point selected that is at (0,0) for it to work, but if you naturally don't have this, you should be able to generate it in the script.

Regards.

Reference Line

Christian_Lauritzen — Tue, 01 Nov 2011 09:14:54 GMT

Hi Jean-Jacques,

There is a fairly simple solution to your problem; you add a linear reference line to a fouth expression. In an XY plot, the first expression represents the X-axist, the second the Y axis and the third the size.

If you add a fourth expression that is a copy of the first, i.e. the x axis it will not be visible, but it is part of the solution. When you add a liniar reference line to the fourth expression, it will be drawn as X = Y as that is its expression.

Hope this helps,

Christian

Reference Line

Tue, 01 Nov 2011 12:03:13 GMT

Thanks Christian!

Brilliant solution! This really helped me as well!

/Elsy

Reference Line

Tue, 01 Nov 2011 18:16:26 GMT

Waou ! very tricky !

thanks Christian ! it's nice to wait almost 2 years for a such answer.

Re: Reference Line

clisboa_noesis — Fri, 25 Jan 2013 18:30:05 GMT

Hi,

I know it's been more than a year but...

Just a hint, if you show the equation for the linear line you can see that it's not exactly X=Y but close enough (y = 1x+1.81e-12 in my case).

Regards,

Carlos

Re: Reference Line

Tue, 19 Feb 2013 10:27:52 GMT

Hi Christian,

It's working well.

Thanks!!!!

Re: Reference Line

Thu, 16 Jan 2014 21:02:14 GMT

Thanks for this solution. Exactly what I needed!

Re: Reference Line

Christian_Lauritzen — Thu, 16 Jan 2014 23:25:18 GMT

I am glad to hear, Lorna! Thank you!

Re: Reference Line

Wed, 26 Feb 2014 01:52:59 GMT

Hi Christian:

I am new to Qlikview and trying to draw a X=Y reference line.

Can I ask how to add the reference line for your last step?

What do you mean by 'liniar reference'? And how to add a reference to a specific dimension?

Thank you

Re: Reference Line

samuel_brierley — Wed, 16 Apr 2014 09:50:50 GMT

Hi I realise this thread isnt being watched anymore but ive tried the above method and cant seem to get it to work,

I have a scatter plot and in expression clicked advance, added a 3rd expression as = 1 for size (I actually dont want to do this becuase it makes my circles too large) and then Ive added a fourth the same as the first and nothing happens.

I know the expression must be correct as the chart works but here it is just incase,

IF(SwitchOnOffVariables.Group.onOffState <> 'STANDBY' and

RampDataFilteringOutput.Loopp1.sORLoopK > 35 and

RampDataFilteringOutput.Loopp2.sORLoopK > 35,

RampDataFilteringOutput.Loopr1.qRLoopK + RampDataFilteringOutput.Loopr2.qRLoopK)

I must have understood you process incorrectly as iot worked for everyone else,

thanks for any help

Re: Reference Line

ThornOfCrowns — Wed, 16 Apr 2014 09:58:36 GMT

Please start a new thread, rather than necro'ing an old post with a correct answer, as many peoplem will see the question marked answered and not look at it.

Re: Reference Line

Wed, 16 Apr 2014 23:15:21 GMT

Hi Samuel:

After adding the fourth expression, you need to check the "Linear" check box for the fourth expression in the "Trendlines" Session which is located at the left bottom conner of "Expression" Tab.

It works for me. Not sure if there is another way to get around the third expression.

Hope this would help.

Cheers,

Re: Reference Line

Tue, 26 Jul 2016 16:10:26 GMT

Thanks Chirstian! Your Solution worked out perfectly!

Re: Reference Line

Fri, 29 Jul 2016 22:56:29 GMT

"Linear reference line" -- I think he means on the "Expressions" tab, where you added the 4th dimension, to use the "Linear" Trendline (bottom-left corner)