topic Re: Need straight table help in QlikView

Need straight table help

ananyaghosh — Mon, 25 May 2015 10:06:14 GMT

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?

Re: Need straight table help

PrashantSangle — Mon, 25 May 2015 10:12:03 GMT

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

Re: Need straight table help

ananyaghosh — Mon, 25 May 2015 10:29:29 GMT

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.

Re: Need straight table help

PrashantSangle — Mon, 25 May 2015 10:33:22 GMT

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

Re: Need straight table help

prajapatiamar38 — Mon, 25 May 2015 10:39:45 GMT

Hello,

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

Please check it out.

Thanks