Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
cmano
Creator
Creator

Fetch value from a table equal-greater or equal-less according to expression.

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
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:
cmano_2-1673342266403.png

For your reference Note that table is not sorted and i have plenty of Process order & characteristics.

Any advise??

Labels (1)
0 Replies