Value lies between which Range

[koushik_btech20]

I have a table which contains the lower bound ,higher bound and a flag(Msg)  and in another table I have attribute wise score. I have to find the score first and match it  with the range(lower bound and upper bound) and display the msg in a text object. I am attaching a qvw. If anyone have any idea please share here.

[tresesco]

Try using Intervalmatch().

[koushik_btech20]

Interval match  function is used in script. But I have to do it in UI section.

[tresesco]

vAvg=Avg(Score)

Expression in th textbox:

=Concat( distinct if(vAvg>=LowerBound and vAvg<=HigherBound, Msg))

[Yousef_Amarneh]

please find the attached, I hope it matches your request

[koushik_btech20]

I have already mentioned that I have to do it in UI part not in script part.

[koushik_btech20]

These expression not works.

[tresesco]

Did you note that vAvg is a variable?

See attached qvw.