Need straight table help

[ananyaghosh]

Hi,

I have two text input filed and I want I give values to them, the values between min value and Max values will be displayed at red color in straight table. Please suggest How to do that thing?

[PrashantSangle]

Hi,

Considering you have two Variables to store min and max value

then

Select Expression -> Click on + symbol->Text Color->

Write if(YourExpression>MinValue And YourExpression<MaxValue,Red())

Note:

Your Expression Replace with Expression

and

MinValue is your minvalue Variable which are taking throug input field

MaxValue is your maxvalue Variable which are taking throug input field

Regards

[ananyaghosh]

Hi,

I have create a QVW. But it does not change the color when I enter input in those text input field. Please check and correct if I have missed anything.

[PrashantSangle]

Hi,

You are missing closing bracket of second Only

Modify as below

=if(only([Value Per SQ Ft]) >=vMinValue and only([Value Per SQ Ft]) <= vMaxValue, Red())

Regards

[prajapatiamar38 · Accepted solution]

Hello,

Sandip Ghosh ,I have made Some changes in your Application It is coming right now.

Please check it out.

Thanks