Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Need straight table help

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?

1 Solution

Accepted Solutions
Creator II
Creator II

Hello,

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

Please check it out.

Thanks

View solution in original post

4 Replies

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

Great dreamer's dreams never fulfilled, they are always transcended.
Creator III
Creator III

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.

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

Great dreamer's dreams never fulfilled, they are always transcended.
Creator II
Creator II

Hello,

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

Please check it out.

Thanks

View solution in original post