How to add a diagonal line on QlikSense Q-Q Plot

[Muhammad91]

Hi, I am currently working on a project that requires me to create a diagonal line on QlikSense Q-Q plot but I dont know how to do that. I have created a scatter plot on QlikSense as attached but now I need to create a diagonal line to see the distribution. Can someone please help me in creating a red diagonal line ?

Under Measure X-Axis: =avg[value]

Under Measure Y-Axis: =NORMINV( 1-(rank(([value])) - 0.5) / count(distinct total [value]) , 0,1)

[mikaelsc]

check with this one:

https://developer.qlik.com/garden/5fbeceaa9dc2b90011ebc57b 

[Muhammad91]

Thanks Mikael but I still can't seems to figure out how to plot diagonal line on the scatter plot where I have plotted qq plot. Can you please let me know here what needs to be done. This would be very very helpful.

[mikaelsc]

under add-ons, add a line... for which you can define 2 pairs of coordinates [x1,y1],[x2,y2]

[Muhammad91]

Hello Mikael, thanks for your help but this wont generate auto trend line. I want the trend line to change based on the distribution. However, I was able to generate a trend line using QlikSense Vizlib scatter plot. It has the option to use trend line. I am trying to generate the confidence arms now in the same plot but couldn't so trying to figure this out.