topic Re: Diagonal reference line in scatter chart in Sense?? in App Development

Diagonal reference line in scatter chart in Sense??

Thu, 05 May 2016 18:49:51 GMT

Hi all ,

How can I plot the diagonal reference line in scatter chart in Qlik sense???

thanks & regards

Prashanth

Re: Diagonal reference line in scatter chart in Sense??

Anonymous — Thu, 05 May 2016 20:01:38 GMT

Under add-ons there is options to add a reference line.

Re: Diagonal reference line in scatter chart in Sense??

Fri, 06 May 2016 10:45:21 GMT

Hi Bella,

Not just reference line, diagonal reference line am looking for.

Re: Diagonal reference line in scatter chart in Sense??

Anonymous — Sun, 08 May 2016 19:33:49 GMT

To get a diagonal line you would need to use a expression that accumulates across the measure on the x axis

Re: Diagonal reference line in scatter chart in Sense??

Jon_M — Fri, 29 Jul 2016 18:02:59 GMT

Bella

Would you have an example of such an expression that might be shared with accompanying explanation of the formulae?

It would be much appreciated.

3rd thread I've read on this subject - one dating back to 2014 asking for a simpler solution to this.

Thanks

Jon

Re: Diagonal reference line in scatter chart in Sense??

Anonymous — Sun, 31 Jul 2016 19:17:33 GMT

What do you want the reference line to represent?

Re: Diagonal reference line in scatter chart in Sense??

Jon_M — Mon, 01 Aug 2016 13:50:22 GMT

Bella

One or both of the following

a 'straight' diagonal line where y=1x=0

a trend line where the ratio of y to x would be a linear average of all individual x and y values.

Essentially I'm looking for outliers and want a line to guide the visual.

To Qlik - not sure why this is delivered functionality for QV but requires users to define expressions in QS. I've seen threads back as early as 2014 asking how to do this. Not really end user friendly / self service if I have to break out the linear regression math text that I've not had occasion to use in decades.

Re: Diagonal reference line in scatter chart in Sense??

Anonymous — Mon, 01 Aug 2016 19:46:44 GMT

My apologies I think I have just proven myself wrong, I tried a bunch of things but am unable also to get a diagonal line. Sorry.

Re: Diagonal reference line in scatter chart in Sense??

Fri, 13 Jan 2017 20:34:47 GMT

Just wondering if you found a solution for this in Sense? Thanks!

Re: Diagonal reference line in scatter chart in Sense??

prashanth1712 — Tue, 17 Jan 2017 10:43:59 GMT

Hi Matt,

We don't have any direct option for this, but I used linest formulas to achieve the same.

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/StatisticalAggregationFunctions/linest_m.h…

Thanks

Prashanth

Re: Diagonal reference line in scatter chart in Sense??

Thu, 19 Jan 2017 14:57:57 GMT

Thanks Prashanth, i'll check out some possibilities

Re: Diagonal reference line in scatter chart in Sense??

Jon_M — Fri, 20 Jan 2017 16:07:53 GMT

Prashanth

Would you be willing to share your load script/example of the formula(e) used to make this happen?

Much appreciated

Jon

Re: Diagonal reference line in scatter chart in Sense??

MyMagic — Tue, 21 May 2019 03:56:47 GMT

Hi,

I realize this is an old thread but I found a solution using the VizLib Scatter Chart. Create a Reference Polygon and add at least 2 coordinates. In my case, i wanted to add a 45 degree diagonal line so I used coordinates (0,0) and (1,1) since my data is in %.

Cheers!