Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

How to do Conditional format for the Values ?

Hello,

I have the table as shown below; where I used the ColorMix wizard for the "Net" field in my table. (Higher Values - Red and Lower Values - Green)

1.PNG

I want the color formatting only to my upper and lower values, not the middle values as shown in the image below;

Desired Output:

Capture.PNG

How do I achieve this, any help is appreciated.

thanks

Bhavesh

1 Solution

Accepted Solutions
bhaveshp90
Creator III
Creator III
Author

Assign 0 to the intermediate expression in the ColorMix wizard which gives the desired output as shown below;

1.PNG

View solution in original post

1 Reply
bhaveshp90
Creator III
Creator III
Author

Assign 0 to the intermediate expression in the ColorMix wizard which gives the desired output as shown below;

1.PNG

View solution in original post