topic box plot, cumulative distribution in QlikView https://community.qlik.com/t5/QlikView/box-plot-cumulative-distribution/m-p/158128#M33339 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Rather weak in math I found the fractile function to get me the 5 values needed for my box plot<BR /> fractile(Deviation, 0.975) ... fractile(Deviation, 0.025)</P><P>The problem I face now is that I will end up with too many values if I have to use each measured value. The idea is to combine values into bins representing value ranges and the element counters for the bins.</P><P>So I have to find the bin where my percentile falls in but can not figure out what function I have to use in Qlik for this.<BR /> ?fractile+? (DeviationBin, BinElementCount, 0.975)</P><P>Hope this is not too confusing</P><P>Jürg</P></BODY></HTML> Thu, 19 Nov 2009 20:40:29 GMT 2009-11-19T20:40:29Z box plot, cumulative distribution https://community.qlik.com/t5/QlikView/box-plot-cumulative-distribution/m-p/158128#M33339 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Rather weak in math I found the fractile function to get me the 5 values needed for my box plot<BR /> fractile(Deviation, 0.975) ... fractile(Deviation, 0.025)</P><P>The problem I face now is that I will end up with too many values if I have to use each measured value. The idea is to combine values into bins representing value ranges and the element counters for the bins.</P><P>So I have to find the bin where my percentile falls in but can not figure out what function I have to use in Qlik for this.<BR /> ?fractile+? (DeviationBin, BinElementCount, 0.975)</P><P>Hope this is not too confusing</P><P>Jürg</P></BODY></HTML> Thu, 19 Nov 2009 20:40:29 GMT https://community.qlik.com/t5/QlikView/box-plot-cumulative-distribution/m-p/158128#M33339 2009-11-19T20:40:29Z