Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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