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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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