Hello guys i use these expressions (boxplots-whiskers)
Top whisker (tw) :
FractileExc(If(Characteristic='γ',Value), 0.75) + 1.5*(FractileExc(If(Characteristic='γ',Value), 0.75)-FractileExc(If(Characteristic='γ',Value), 0.25))
Low whisker (lw):
FractileExc(If(Characteristic='γ',Value), 0.75) + 1.5*(FractileExc(If(Characteristic='γ',Value), 0.75)-FractileExc(If(Characteristic='γ',Value), 0.25))
I have these results from above expressions : 19.62375 (tw) & 7.93375 (lw).
![cmano_1-1673342045995.png cmano_1-1673342045995.png](https://community.qlik.com/t5/image/serverpage/image-id/97649i7E55D4F56ED48ED8/image-size/medium?v=v2&px=400)
For tw i want ta fetch the first equal less value from the result i.e 17
For lw i want ta fetch the first equal greater value from the result i.e 8.4
Table:
For your reference Note that table is not sorted and i have plenty of Process order & characteristics.
Any advise??