change background color using >=value1<=vlue2 in input field

[#1]

Hello,

I have an input field where the user enter for example : >=100<=200

I need to use this condition to change the background color for an expression using the background color property of the expression something like this:

if(MyExpression>=100 and MyExpression<= 200, Green(),Yellow()).

how can i do it?

thanks

[amars]

Hi Layal,

Try this way

Thanks,

Amar

[#3]

the problem is not with how can i use my expression in the background color property the problem is how to transform the input value >=100<=200 to use it as if(Column(1)>=100 and Column(2)<=200,Green(),Yellow())

[amars]

Hi Layal,

See attached Example.

As you can see in my expression, I am using Column(1) as I have only one Expression, Similarly you can use the corresponding Column No in ur Expression for the color.

Hope this helps.

Thanks

Amar

[#5]

these are my input fields

i need to use them in a condition on my expression and give each result in my table a background color depending on A,B,C

[#6]

Hi you shoult use the visualization properties on whatever expression you need it

vLUG and vToleranz are my variables and the are being set by an input field and LUG is on tob is my expression hope this helps

[amars]

Hi Layal,

After lot of efforts was able to put it the way u want.

Please check the attachment.

Thanks

Amar