Hi Everyone,
I have a Probability plot that I have plotted on QlikSense using Qlik Scatter Plot. After doing lots of investigation, below are the formulae I have put for creating this probability plot but I have few issues.
I need to change the Y-Axis scale between 0 to 1 equivalent (i.e. probability). Can anyone please help me with this ?
Currently below is what we have plotted in QlikSense:
Dimension[Bubble] = =[Value]
Measure X-Axis = Avg([Value])
Measure Y-Axis = =NORMINV( 1-(rank(([Value])) - 0.5) / count(distinct total [Value]) , 0,1)
