Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

box plot, cumulative distribution

Hi

Rather weak in math I found the fractile function to get me the 5 values needed for my box plot
fractile(Deviation, 0.975) ... fractile(Deviation, 0.025)

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.

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.
?fractile+? (DeviationBin, BinElementCount, 0.975)

Hope this is not too confusing

Jürg

0 Replies